SAP Knowledge Base Article - Public

2280314 - Renaming Column Headers while using Live Data as the data source in Online Report Designer (ORD) / 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

  • SAP SuccessFactors HCM Suite
    • Online Report Designer

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, Field, Center, Designer, change , KBA , rename column , ord , column header , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HXM Suite all versions