Running alternate hierarchy

ChrisMcCarthy

We currently run the following hierarchy within our system

This works for how the business currently reports, however in the future will need to still be able to report in the above hierarchy but then we would also need to report in the following structure. As you can see the bottom level would be the same, however I would then need it to roll up into different divisions

How would I go about achieving this? Is it possible to run what I'm terming alternate hierarchy? Welcome any suggestions on what the best practice way of doing this would be.

Thank you

Sai_Bharadwaj_Venati

Hi, we need to create parallel/alternate hierarchy for this…. You would need to create entire new hierarchy starting from Employee list to Division

Alternatively if this new hierarchy is required for limited no of modules…you can create separate hierarchy (Op division 1 to division 3) and then create a module with original hierarchy list (this will consume model space and probably not a best practice)

wedd26

Step

create the function hierarchy

Step 2. create the Operating Unit Hierarchy

wedd26

Used the Functions and Operating Units are dimensions in your visual model. so users can slice and dice as per need