I have created a Hierarchy with our organizational Structure
Location -> Unit -> Department -> Group -> Team
Each of the element has an ID
On the other hand I've a fact table with plan data per Employee. Each employee has as attribute OrgID.
I've modified the fact table to have for each row the OrgId.
Now I've to create the Matadata and there I've the issue that I can link the OrgID of the fact table only with one level of the Hierarchy?
But in our org, an employee can belong to whatever level
No clue how I can get the Hierachy build
Thank you so much
erwin