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'
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.
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.
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