SAP Knowledge Base Article - Public

2452683 - Unable to fetch Supervisor's Supervisor details in Advance Reporting query

Symptom

  • 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?

Environment

  • 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

Report output.png

Cause

  • 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

Org Structure.png

  • 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

Screenshot 5.png

  • 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.

Resolution

Possible workaround:

Option 1:

  • User running the report must be granted to view data of Second Level Manager in Personal Information, Employment Information, Biographical Information portlets.

Option 2:

  • Create Ad Hoc Report of Employee Profile domain. Fetch Manager's Manager details from "Manger's Manager Information" table

Ad Hoc Report.png

Option 3:

  • Create Live Data ORD query based on Employee Profile table and fetch columns from "Manger's Manager Information" table

Live Data ORD.png

Keywords

  • 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
, KBA , LOD-SF-ANA-ODS , Advanced Reporting , LOD-SF-ANA-ORD , Online Report Designer , Problem

Product

SAP SuccessFactors HCM Core all versions