Symptom
Country/Region fields are blank on Story report when using join with Personal Information.
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 HCM Suite
Reproducing the Issue
- Create a Story report
- On the query, add Personal Information > Country/Region
- Select the Country/Region columns
- Click on Preview Query
- Note that the Country/Region fields will appear blank
- If you create a report using only the Country/Region Foundation Object, the information will be visible
Cause
Missing permission for Nationality.
From a configuration perspective, the Nationality field derives its values from the Country/Region field. Therefore, access to both fields is essential to generate the report accurately. The report relies on a join between the Personal Information and Country/Region tables, linked by the Country/Region field (which also serves as the Nationality field).
Resolution
- Go to Manage Permission Roles
- Edit the role for the affected user
- Grant the permission Employee Central Effective Dated Entities -> Personal information -> Nationality
See Also
Keywords
country/region, blank, missing permission, nationality, rbp, user, not showing, story , KBA , LOD-SF-ANA-SAC-RBP , Role Based Permissions & Authorizations , Problem
SAP Knowledge Base Article - Public