SAP Knowledge Base Article - Public

3311229 - Export to CSV shows dot (.) as digit separator in SAP Analytics Cloud

Symptom

  • When number formatting is set to comma (,) as digit separator, the CSV exported, with scope All, shows dot (.).
  • When exporting as Point of view, the number formatting preserves the comma as digit separator.

Environment

SAP Analytics Cloud 2023.2.6

Reproducing the Issue

  1. Log in to SAC tenant
  2. Go to your profile settings and choose comma (,) as Number Formatting (e.g. 1 234,56)
  3. Create a simple model 
  4. Create a story on top of that model and add a chart or a table with measures included 
  5. Export the chart including formatting 
  6. Open the CSV file exported and note that the numbers are using dot (.) as digit separator
  7. Go back to SAC and export the table as CSV, Scope All, and include formatting
  8. Open the CSV file exported and note that the numbers are using dot (.) as digit separator

Cause

The issue is currently under investigation by development.

Resolution

The issue is currently under investigation by development.

Workaround:

  • While exporting, choose Point of View as Scope.

See Also

Keywords

SAP Analytics Cloud, SAC, Profile, Settings, Comma, ",", Formatting, "1 234,56", "1.234,56", Measures, Chart, Table, CSV, Dot, ".', Digit, Separator. , KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem

Product

SAP Analytics Cloud 1.0