SAP Knowledge Base Article - Public

2709678 - Column name is showing additional information/codes - Advanced Reporting

Symptom

The column name is showing the column code when you are creating a query in Advanced Reporting.

"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 Workforce Analytics
  • Advanced Reporting

Reproducing the Issue

  1. Go to Home>Reporting>Create a new Canvas Report;
  2. Try to create a new Advanced Reporting query and select the domain (e.g. Employment);
  3. Note that some column names are showing the field code on column name: 

    supervisor_code.PNG
    supervisor_report.PNG

Cause

This is an expected behavior as the views are automatically created in Advanced Reporting.

Resolution

To have a better reading of the column's names in the report, you can rename it (it will change the column name only for the specific report where you changed the column name).

  1. In the report's edit mode, go to the "Columns" tab;
  2. Click on the name of the column that you want to change;
  3. Click on the "Rename Selected Column" button:

    edit_button.png
  4. Insert in the correct column name in the "Name:" field and then click in "Ok":

    rename.png

Keywords

Advanced Reporting, field name, column name, , KBA , LOD-SF-WFA , Workforce Analytics & Planning , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-ANA-ODS , Advanced Reporting , Problem

Product

SAP SuccessFactors Workforce Analytics all versions