SAP Knowledge Base Article - Public

3049206 - Rows of the exported table in CSV file are not matching with the rows total in SAC view in SAP Analytics Cloud (SAC)

Symptom

  • During CSV export the exported amount of rows from a table are not the same compared to the rows total in SAC view.
  • The number of rows are not the same even by exporting the table repeatedly, or by changing the delimiters (e.g. comma, semicolon, tab etc.).
  • This has been experienced with large amount of data.

Environment

SAP Analytics Cloud (Enterprise) 2021.02.11

Reproducing the Issue

  1. Login to SAC.
  2. Open story with a table of large amount of data.
  3. Switch to Edit mode.
  4. Exporting Data as a CSV File
  5. Export settings e.g. :
    • Test1: File Type: CSV // Scope: All // Include Number Formatting: unselect // CSV Delimiter: Comma ,
    • Test2: CSV // Scope: All // Include Number Formatting: unselect // CSV Delimiter: Semicolon ;
    • Test3: CSV // Scope: All // Include Number Formatting: unselect // CSV Delimiter: Tab
  6. Compare the number of rows with the totals in SAC table or compare the rows in the exported CSV files => the number of rows are different.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

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-COR , SAC Core story functionality - widgets, geo, design, etc , Problem

Product

SAP Analytics Cloud 1.0