SAP Knowledge Base Article - Public

2436837 - How to extract Managers Information in Advanced Reporting

Symptom

  • How to extract Managers Information in Advanced Reporting
  • How to know if a user is supervisor/manager or has direct reports through reporting.

Environment

  • SAP SuccessFactors HCM Suite
  • SAP Successfactors Workforce Analytics
  • Report Canvas on Advanced Reporting query

Resolution

  • There is no predefined field which can directly tell you if the user is a manager or not however there is a field which gives you the Number of direct reports of a user which can be utilized to extract managers data.
  • Field is available on the advanced reporting
  1. Open the table Users
  2. Open the dropdown for User Sys Info
  3. Users Sys Directreports
  • If the value of the field Users Sys Directreports is > 0, it implies the user is a supervisor with direct reports.
  • You can put a filter Directreports is not equal to 0 to extract only Managers records

directreport.PNG

Keywords

Direct Reports - Users Sys Direct reports - Manager Information , KBA , LOD-SF-ANA-ODS , Advanced Reporting , How To

Product

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Workforce Analytics all versions