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

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.

• SAP SuccessFactors HXM Suite
• Report Canvas
• Advanced Reporting

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'

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.

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.

The FINAL RESULT: Renamed field in the result.

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