SAP Knowledge Base Article - Public

3025484 - Exporting from a widget with Top N filter ignores Measures in SAP Analytics Cloud (SAC) & SAP Digital Boardroom


The following behavior occurs in SAP Analytics Cloud (SAC):

  • Trying to export a widget, that does contain measures and a Top N condition, results in a csv that only contains dimension data, measures are excluded from the export


  • SAP Analytics Cloud (Enterprise) 2021.3.5
  • Live HANA connection

Reproducing the Issue

  1. Create a story based on a Live HANA data connection
  2. Insert a widget with a chart that has dimensions and measures 
  3. Add a Top N filter
  4. Export the widget to csv or xslx, the measures are not in the exported file


This issue is currently under investigation by development.


This issue is currently under investigation by development.

Workaround: remove the Top N filter, if required SAP Analytics Cloud will automatically add a Top Auto filter and export will be as expected

See Also

Your feedback is important to help us improve our knowledge base.


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0