SAP Knowledge Base Article - Public

3024019 - When exporting table to the CSV file using the scope All, formatting is not applied / applied incorrectly in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Symptom

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

When exporting table to the CSV file, formatting is not applied / applied incorrectly

Environment

SAP Analytics Cloud (Enterprise) 2021

Reproducing the Issue

  1. Login to SAC.
  2. Open the table which contains data in the monetary amount.
  3. On a PC, in the Control Panel, go to Clock and Region ->  Region -> Additional Settings and verify the separator formats.
  4. Open Profile preferences, to select number formatting (1 234,56) and currency position (1234 Million $). 
  5. Select the table.
  6. Select Export - File Type 'CSV; Scope 'All', Tick "Include number formatting'.
  7. Click OK.
  8. Observe that the data is exported in the format "35,496,674.22€" while expected format is "35 496 674,22 €".
  9. Select the table.
  10. Select Export - File Type 'CSV; Scope 'Point of view', Tick "Include number formatting'.
  11. Observe that the data is exported in the expected format "35 496 674,22 €".

Cause

The Export to CSV All scoped feature directly takes the data from the database and drops it into the exported document; there is no additional formatting applied. What is seen in the document is the data formatted as it comes from the database, not as it does in the story.

In the Point of View option, it takes the formatted data directly from the table and so can provide this extra formatting.

Resolution

Enhancement requert https://influence.sap.com/sap/ino/#/idea/255896 created.

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,, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, export, CVS, CSV, decimal, comma, point of view, all, format, formatting, incorrect, , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0