I am new in the Anaplan. Could you please explain me how to create an alternate hierarchy with example?
Please find the below sample hierarchies which I want to create in a single list, where the cost centers have two parent in a single list.
Thanks for your reply. Will try this and let you know if need any help.
Presently, this can not be done within one list but you can "fake" it out by using filters. To do this:
Hope this helps,
This is a bit confusing topic to explain but extremely important to understand.
Let's agree that Alt Hierarchies are mainly used to display the data by different grouping, not to recalculate data.
For example, you might want to display Product revenue based on Department for one User Role and on Distributor for another User Role.
Since the Product revenue won't change if we group it under Department or under Distributor, we really should not recalculate the Product revenue under Distributor but rather retrieve the same product revenue under Department.
To do so, we should first create the Alt list hierarchy (Distributor list)
You already have a module that calculates Product Revenue By Department (Module A) --> Dimensioned by L2 Product Now you want to create another module that displays the Product Revenue by Distributor (Module --> Dimensioned By L2 Alt Product.
Even though we will have a list item in Module B named Product 1 and a list item in Module A also named Product 1, from Anaplan's point of view these 2 list items are completely different even though they have the same name and code.
We need to Map each L2 Alt Product list items under the Distributor list to its equivalent in the L2 Product under the Department list.To achieve that we do the following:
Now that we have the mapping ready, we can return the Product Revenue Data in the module dimensioned by the L2 Alt Product list (Module B) from the already calculated Product Revenue Data in Module A for L2 Product, using the following formulaModule B.Revenue = 'Module A'.Revenue[LOOKUP: Mapping Module.Department Product Item]
It looks complicated but it really isn't if you understand some basics about how data - especially in lists - relate to each other.
My intention is to create some screenshots, If I forget please remind me
If you have any questions please let me know.
This topic is very interesting for me, as we are exploring this topic as a future development
We are looking to build functionality that will allow multiple parents off a single child member and specify which hierarchies should be used in which part of the model
This will obviously save a lot of the complexity and mapping (as above), as well as saving model space, because the data does not need to be repeated for the child member.
It is also very relevant for our new calculation engine as difference levels within hierarchies are a key component of the calculations needing to be performed
To help me capture a full set of use cases please could you reply with examples of how and why this functionality would help you (i.e. industry, use case, complexity etc.)
I have a lot "in my head" already, but it will be great to validate those against the field requirements
Many thanks in advance
Any update on the simplified multiple/alternate hierarchy creation capabilities?
@einas.ibrahim - Would you be able to post screenshots of the example you described above please?