SAP Knowledge Base Article - Public

2575227 - Person ID or Employee ID blank for some users in Report Canvas Advanced Reporting

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

  1. Logged in as admin user and open a report in Advanced Reporting
  2. See that Person ID / Employee ID column is showing data for all employees
  3. Proxy as a manager and open the same report
  4. 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.

person id.jpg

Resolution

Provide RBP permission and proper target population to Biographical Information under Employee Data.

biographical.jpg

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

Product

SAP SuccessFactors HCM all versions