SAP Knowledge Base Article - Public

2193658 - What encoding is used for Report export to CSV via the Online Report Designer (ORD) tool?

Symptom

You want to know what encoding, for example UTF8 or ANSI, is used for Report export to CSV via the Online Report Designer (ORD) tool?

Environment

  • SuccessFactors HCM Suite
  • Reporting and Analytics
  • Online Report Designer (ORD)

Reproducing the Issue

  1. Login to the desired instance
  2. Analytics - Analytics
  3. Select Report Designer
  4. Open/Preview any report
  5. Select Export to CSV
  6. Save/Open the report with Notepad and you can see the 'Encoding' used when you try to save the file again

Cause

System behaviour as designed.

Resolution

Downloading a report via the Online Report Designer (ORD) tool into CSV format will use the ANSI encoding.

You may convert the encoding as follow:

  1. Save your Excel CSV as “.CSV” file
  2. Open the .CSV again using NOTEPAD
  3. Save again with NOTEPAD using the “desired” encoding

Keywords

UTF8, ANSI, encoding , KBA , report export , utf8 or ansi , ansi encoding , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Suite all versions