SAP Knowledge Base Article - Public

3007657 - Garbled code is displayed in CSV file when setting profile language as Polski and exporting model as file on SAC

Symptom

  • Garbled code is displayed in CSV file when setting profile language as Polski and exporting model as file on SAC

Environment

  • SAP Analytics Cloud 2020.21
  • SAP Analytics Cloud 2021.2

Reproducing the Issue

  1. Logon SAC.
  2. Go to Profile Settings, set language as Polski.
  3. Open a model.
  4. Export model as CSV file.
  5. Open the file, garbled code is displayed in some cells.

Cause

The behaviour of the export is working as expected on SAC, problem is Excel does not open the CSV in UTF-8.

Resolution

Workaround:

  1. Open Excel to blank document.
  2. Main Menu -> Data -> Get Data -> From File -> From Text/CSV.
  3. Specify the CSV.
  4. Set "File Origin" to Unicode UTF-8.

See Also


Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

Garbled code, CSV, Polski, export, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0