SAP Knowledge Base Article - Public

2752395 - How to report on Position Hierarchy Level field

Symptom

  • How to create a query / report in Story Reports or Advanced Reporting to fetch all levels in Position Hierarchy? 
  • How to modify the "Employee Hierarchy Report Template (5 levels)" EC Standard Report to fetch All levels position?

Environment

SAP SuccessFactors HCM Suite

Cause

In Story Report, there is not an available standard field that provides you with this specific information. To report on Position Hierarchy Level, you would need to create a calculated column in the report.

Resolution

In Canvas report, you can find the field under Employment > Global Job Information > User sys info > User Team Info > Level in Org

For Story Report, there is a standard report that provides you with the employee hierarchy information. 
The report can be imported from the content store, it is called "SF_EMP_Employee_Hierarchy_Report_Template_(5_Levels)_v2.0".
Please refer to KBA 2960782 - Story Report - Implementing Standard Story Templates on how to import and validate the standard template. 

If a report is already created and the fields needs to be added to it, it is needed to create a calculated column to the report.
The calculated column needs to be configured using the IF formula:

Data Source: Job Information
Formula: IF(ISNULL([Employment#Supervisor#User ID]), 1, IF(ISNULL([Employment#Supervisor + 1#User ID]), 2, IF(ISNULL([Employment#Supervisor + 2#User ID]), 3, IF(ISNULL([Employment#Supervisor + 3#User ID]), 4, IF(ISNULL([Employment#Supervisor + 4#User ID]), 5, 6 ) ) ) ) ) 

If "Hierarchy Level" as an standard field should be reportable in story report without the need to create a calculated columns, please submit an enhancement request via Customer influence (https://influence.sap.com/sap/ino/)
(All enhancement requests are reviewed by our Product Management team which, if successful, are developed and implemented in a future product release.)
KBA 2090228 - How to Submit Ideas for SAP SuccessFactors Products

See Also

Keywords

Position Hierarchy, All Levels, All Positions, Advanced Reporting, Story, Position Level, Level, Hierarchy, Level In Org, , KBA , LOD-SF-ANA-SAC-QDS , Query Designer - Filter, Calculated Column, Params , LOD-SF-ANA-SAC , Stories in People Analytics , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To

Product

SAP SuccessFactors HCM Suite all versions