Query for extract Hierarchy Manager
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.