SAP Knowledge Base Article - Public

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

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

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

Product

SAP SuccessFactors HCM suite all versions