SAP Knowledge Base Article - Public

2549769 - Export failed: The data cannot be displayed... exporting to CSV in SAP Analytics Cloud

Symptom

You are exporting the data in a table or chart in SAP Analytics Cloud and you get the following error message:

Export failed: The data cannot be displayed because the query returned too many records. Please try filtering your data.

Environment

  • SAP Analytics Cloud 2017

Cause

The number of cells exported exceeds the limitations on SAP Analytics Cloud documented in https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/405da2ee4e604ed4aa11bab4d7061ddb.html

The following limitations apply to the export:

  • Maximum number of columns: 60.

  • Maximum number of cells of data: 3 million.

  • Any filters applied to the chart are applied to the data export.

    The export does not contain information on which filters or data sources are used.

  • Formatting (such as cell color, font styles, and so on) will not be exported.

  • Hyperlinks are removed.

  • Hierarchies are flattened.

Resolution

Add filters to reduce the number of cells exported.

Exceeding the 3 million records is easier than expected when you export large number of columns as you need to calculate the total number of cells as # Columns * # Rows.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAP Cloud for Planning, exporting, save, excel, sc4p, c4p, , cloudforplanning, Hana Cloud for Planning,  Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting,SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , Problem

Product

SAP Analytics Cloud 1.0