If you are unable to create a new account, please email support@bspsoftware.com

 

Connect Employee to a Organistion Dimension

Started by erwink, 10 Nov 2015 03:31:24 AM

Previous topic - Next topic

erwink

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