SAP Knowledge Base Article - Public

2986096 - Some records are not shown in table although data exists in SAP Analytics Cloud (SAC)


  • Some records are not shown in table although data exists in SAP Analytics Cloud (SAC)
  • Data will show after adding a page filter then remove it 


  • SAP Analytics Cloud (Enterprise) 2020.21.5

Reproducing the Issue

  1. Open the problem story.
  2. Click on the table which has 30,000 rows and select   '' (More Actions)  '' Export.
  3. Save as CSV file.
  4. Filter the CSV file with some value, no value shows.
  5. Go to the story, add a page filter, filter with same value with step4, note that value shows.
  6. Remove the filter, note that it changes to 30, 003 rows.
  7. Export the table as CSV and filter with the value, this time value shows.


This is a behavior by design.


If there are new members added in the model, then those members will only be displayed if you refresh the filters as well.

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, missing, lost , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0