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.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

  • SAP SuccessFactors HCM Suite
    • Advanced Reporting

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, DirectReports, Users Sys Info, Direct, reports, Manager, Information, find, if, is, manager, only, report, Center, Advanced, Canvas, Online, Designer , KBA , LOD-SF-ANA-ODS , Advanced Reporting (ODS) , How To

Product

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