- Realms query does not fetch Second Level Manager's data.
- User running the report have permission to view the Second Level Manager in the Org Chart. But user is unable to fetch Second Level Manager's data in Advance Reporting Query.
- Why Supervisor's Supervisor details are not appearing in Advance reporting query?
- Advanvce Reporting
Reproducing the Issue
- Create an Advance Reporting Query
- Fetch Employee ID from Global Job Information table
- Fetch Second Level Manager's (Supervisor's Supervisor) details from "Supervisor Supervisor Global Job Information" table
- Put a filter on Specific Employee ID (Example: Employee ID = 1234)
- Second Level Manager's Details are not coming in the Advance Reporting query for the Employee ID - 1234
- User running the advance Reporting query is ABC
- Second Level Manager of Employee ID - 1234 is XYZ
- Go To Employee Profile > Search for the user 1234 > Go to Org Chart > Go To 2 level up to check Second Level manager - XYZ
- Go To Employee Profile > Search for the User XYZ > Check if the user running the report have permission to view Portlets - Personal Information, Biographical Information, Employment Information
- If the user ABC does not have permission to view data of Second Level Manager (XYZ) in Personal Information, Employment Information, Biographical Information portlet then second level manager's details will not come in Advance Reporting Query while user ABC is running the Realms query.
- User running the report must be granted to view data of Second Level Manager in Personal Information, Employment Information, Biographical Information portlets.
- Create Ad Hoc Report of Employee Profile domain. Fetch Manager's Manager details from "Manger's Manager Information" table
- Create Live Data ORD query based on Employee Profile table and fetch columns from "Manger's Manager Information" table
- Second Level Manager Details
- Supervisor's Supervisor Details
- Advance Reporting Query
- Ad Hoc Report
- ORD live Data
- Manager's Manager Information
- Supervisor's Supervisor Global Job Information
SAP SuccessFactors HCM Core all versions