Running alternate hierarchy

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

Accepted answers

All comments

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

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…