Symptom
Issues with reporting National ID information in Advanced reporting.
This KBA talks about two different Issues regarding National ID portlet fields.
National ID Card Type :
National ID card type filed is pulling Fields Option id not the Value/label.
Is Primary :
Is Primary values are not correct, reported 't' rather 'Yes' in same table.
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
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
- Advance Reporting
- Analytics & Reporting (Ad Hoc, YouCalc, ORD)
Reproducing the Issue
Navigate to Advanced Reporting.
Select the National Id Portlet.
Drag and drop the complete table.
You can find the discrepancy in all the fields for the scenario mentioned above.
Cause
Incorrect Configuration and settings at the data source (Employee Central)
This leads to incorrect joins in metadata views in advanced Reporting and in turn the issues stated above.
Resolution
For National ID Card Type:
The labels for this field aren't supported yet.
For Is Primary:
The data that is being shown in Advanced Reporting for this field is being pulled from the table itself i.e. it is the data that is stored in the table.
In order to show the values "Yes"/"No", a picklist will have to be configured in the data model for this field to show the desired values.
Keywords
National Id Card Type, National Id, Portlet, Advanced Reporting, True / False, Yes / No, Label, External Code , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem