You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Query for extract Hierarchy Manager

Received Response

Hi there ,

we need to reconstruct the hierarchy of a user's managers via a query in BI.

The real problem we encounter when a manager then has several active assignments and therefore there are several managers linked.

We would need to have a sort of hierarchical tree for the users. Is there a table in which the hierarchy is saved, i.e. the one we see through the interface? Or has anyone already created a query of this kind and could help us?

To make myself understood, I would need to create the hierarchy that you find in the example image below.

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!