SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • 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

Cause

This issue is currently under investigation by development.

Resolution

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.

Keywords

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

Product

SAP Analytics Cloud 1.0