SAP Knowledge Base Article - Public

2909185 - How to rename a field/ column in Advanced reporting query?

Symptom

Rename a field/ column selected in Advanced reporting / ODS query.

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 HXM Suite
    • Report Canvas
    • Advanced Reporting

Reproducing the Issue

In advanced reporting, while creating a query, we may need to rename a field.

For example, in advanced reporting, we have a field named: 'Users Sys Id'; we want to rename the field to 'User ID'

BeforeAfter.PNG

Resolution

In advanced reporting query, it is possible to rename the field in two ways:

Way 1:

  • Select the field in the query which you want to rename. 
  • Once selected, edit the table in Objects section to see the list of the fields.
  • The selected field will have the option : [A] beside the field, which when clicked goes to Rename field dialog box.
  • Rename and save, the renamed field will appear in the Object section.

RenameField1.PNG

RenameField6.PNG

Way 2:

  • Select the field in the query which you want to rename. 
  • Once selected, go to the Columns section and select the field there.
  • Click on the 'Rename Selected Column' field and go to Rename field dialog box.
  • Rename and save, the renamed field will appear in the 'Column Display Name' section and in the report as well.

RenameField3.PNG

RenameField4.PNG

The FINAL RESULT: Renamed field in the result.

RenameField5.PNG

Keywords

Advanced Reporting, Rename, Field, ODS, Query, Column Display Name, Column , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA-ORD , Online Report Designer , How To

Product

SAP SuccessFactors HCM Core all versions