SAP Knowledge Base Article - Public

2352303 - Advanced Reporting - Issues with the National ID Portlet and fixes.


Issues with reporting National ID information in Advanced reporting.

This KBA talks about three different Issues regarding National ID portlet fields.

Nationality Field :
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 :
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.



Advance reporting



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 National Id
Advanced Reporting
True / False
Yes / No
External Code   , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem


SAP SuccessFactors HXM Suite all versions