SAP Knowledge Base Article - Public

3618561 - Column headings of tables are not getting reflected in exported csv file with 'All scope' option in SAP Analytics Cloud ( SAC )

Symptom

Headings of columns is changing while exporting the table to .csv with 'All' scope selected.

Environment

SAP Analytics Cloud 2025.1.10

Reproducing the Issue

  1. Login to SAC
  2. Open the story in view mode
  3. Click on context menu for table widget (3 dots)
  4. Click on Export
  5. Select file type as 'CSV'
  6. Select scope as 'All'
  7. Check 'Include Formatting' checkbox
  8. Click on Ok

Notice: The headers of the columns in CSV file is different from the SAC story.

 

Cause

Exported file reflects the original technical names from the data source or model, and these cannot be altered during the 'export all' process via the current design of the system, even if it is getting reflected in SAC.

Resolution

Change the headings of the columns in the model or data source level, from where the changes will correctly reflect in both the SAC story and exported file.

See Also

Keywords

headings, columns, table, story, model, export, csv, sac , KBA , LOD-ANA-UNS-EXP , Unified Story PDF/PPT/Excel/CSV Export , Problem

Product

SAP Analytics Cloud 1.0

Attachments

Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png
Pasted image.png