Symptom
-
Person ID or Employee ID column is blank for some users in Advanced Reporting
-
The target population to see Employee ID field is correct in RBP
- A Pivot Table report shows the error message "Role based security prevents the viewing of this component"
Environment
- SAP SuccessFactors HXM Suite
- Report Canvas Advanced Reporting Query
Reproducing the Issue
-
Logged in as admin user and open a report in Advanced Reporting
-
See that Person ID / Employee ID column is showing data for all employees
-
Proxy as a manager and open the same report
-
See that Person ID / Employee ID column is blank
Cause
The Person ID (it can be configured as Employee ID) belongs to Biographical Information table and the user running the report must have permission to this table.
Resolution
Provide RBP permission and proper target population to Biographical Information under Employee Data.
Keywords
Person ID Employee blank missing empty for some user in Advanced Reporting report Realms Online Report Designer ORD - Role based security prevents the viewing of this component pivot table , KBA , person-id-external , person external id , gpid , gpid permission , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To