Issues with reporting National ID information in Advanced reporting.
This KBA talks about three different Issues regarding National ID portlet fields.
There are 3 Nationality field has been configured " Nationality 1, Nationality 2,Nationality 3 ' respectively however in Advance Reporting for Nationality 2 and for Nationality 3 fields, the Label and External name filed is missing but for Nationality 1, the Label and external code are visible.
National ID card type filed is pulling Fields Option id not the Value/label.
Is Primary values are not correct, reported 't' rather 'Yes' in same table.
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.
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.
For Nationality Fields labels:
A metadata reload from the Analytics server is required to resolve this issue
Please create a support incident and quote this KBA.
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.
National Id Card Type
True / False
Yes / No
External Code , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Problem