Symptom
Generic Object type fields in Reporting tools produces numeric values instead of labels (Internal IDs instead of Labels).
Environment
SAP SuccessFactors HXM Suite
Reproducing the Issue
Running the Report
- Go to Reporting
- Create/run any Report
- See that the field displays a numerical value instead of label
Verify if the field type is Generic Object
- Go to Admin Center > Configure Object Definition
- Object Definition > MDF object
- Look for the field, check Data type column = Generic Object
Cause
System is working as designed.
Resolution
It is by system design that fields from the MDF object, with 'generic object' data type are fetching numerical values instead of labels / descriptions in the reports.
It is not yet feasible to insert a code in the system to convert these internal IDs to reports as it will hugely impact or cause performance degradation when running the report.
Alternatively, if the options/values in this field are few, report users may export and use search and replace these internal IDs in Excel/Spreadsheet with the corresponding labels for offline reference.
Keywords
ECT-83833, 2988243, Generic Object, report, canvas, advanced reporting, detailed reporting, adhoc, table, ad hoc, code, numeric, number , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem