SAP Knowledge Base Article - Public

2280314 - Renaming Column Headers while using Live Data as the data source in Online Report Designer (ORD) / Report Canvas reports

Symptom

While Advanced Reporting data source has an explicit option to rename column headers, Live Data doesn't.
This article explains a work around that allows the renaming functionality, with the help of Calculated columns.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental

Environment

  • Analytics
  • Online Report Designer (ORD)

Resolution

  1. From the Menu select Edit then Calculated Columns.
  2. Create a new Calculated column with the desired name (e.g Employee Status) and Add the field you would like the data from. For this example, Status.
    • Calculated Column designer.jpg
  3. Save and display the Calculated Column.
    • enabled column.jpg
  4. Make sure the New column reflects the desired result by comparing it with the existing field. 
    • Renamed + original Column header.jpg
  5. You can then Hide the original column and just display the one with the 'New' Header's name.
    • Renamed Column header.jpg

Keywords

  • Live Data
  • Column Header rename
  • Report Canvas
  • Detailed Reporting
  • ORD
  • Rename column
  • Rename Field
, KBA , ord , column header , rename column , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core all versions