SAP Knowledge Base Article - Public

2957353 - Story filter information is empty in the Information on Query sheet in the exported Excel from story in SAP Analytics Cloud (SAC)

Symptom

When export the table in a story with story filters to Excel, in the Information on Query sheet of expoerted Excel file, the stroy filters infroamtion is empty.

Environment

  • SAP Analytics Cloud (Enterprise) 2020.8.22

Reproducing the Issue

  1. Create a story in SAC.
  2. Add a table to the canvas and add one dimension and measure to the table.
  3. Add a story filter.
  4. Export the table to file type "XlSX" and check option "Include Formatting".
  5. Open the exported Excel file and switch to the sheet "Information on Query", notice that the Filters information is empty.

Cause

  • The XSLX export is exporting the data which is displayed in the table. Story and page filters are affecting the displayed data. 
  • A batch XSLX export for several story filter members is not available in the product yet. Currently it is also not planned and needs to be treated as a feature request within: https://influence.sap.com/sap/ino/#/campaign/884

Resolution

  • A workaround could be to use Scheduling to PDF allows this for the whole story/app, but the output format is PDF, not XSLX. 

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 , Model, Story Design & Visualizations , Product Enhancement

Product

SAP Analytics Cloud 1.0