2752395 - How to report on Position Hierarchy Level field - People Analytics

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

SAP SuccessFactors HCM Suite

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. Kindly check below how to do that.

There is an Standard report that provides you with the Employee Hierarchy information. 

You can import the report on the content store available on Report Centre. The name of the report is "SF_EMP_Employee Hierarchy Report Template (5 levels)_v2.0". You can refer to KBA 2960782 - People Analytics - Implementing Standard Story Templates to check how to import and validate the standard template. 

If you already have a created report, and would like to add only this specific field 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
Column ID: Level
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 ) ) ) ) ) 

This formula would help you in fetching the desired data. 

If you think having "Hierarchy Level" as an standard field available for you to report on, without the need to create a calculated columns is a great fit to your business needs, we strongly encourage you in creating an enhancement request. 

Please check how to do it on KBA 2090228 - How to submit enhancement ideas for SAP SuccessFactors Products.

Employee Hierarchy Report Template (5 Levels)
Technical Documentation for Employee Hierarchy Report Template (5 Levels)
Employee Hierarchy Report Stories

Position Hierarchy, All Levels, All Positions, Advanced Reporting, People Analytics Story, Position Level, Level, Hierarchy. , KBA , LOD-SF-ANA-SAC-SDS , Story Designer - Story & Formatting , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-ANA-SAC , Stories in People Analytics , How To