Conditional Parenting

CommunityMember113876

Hi all,

 

I've got this situation where my region hierarchy is dependent not just on country but by the entity under which a sale is made. The table below is how I'd like the parenting to work. Region L3 entries then map on a 1:1 basis to Region L2 and again to L1. The entity specific region may roll up along with the geographical ones to roll up together.

 

Entity	Country (Region L4)	Region L3
Entity 1	France	Entity specific Region
Entity 1	China	Entity specific Region
Entity 2	France	Europe
Entity 2	China	Asia
Entity 3	France	Europe
Entity 3	China	Asia

 

At the moment I've got a mapping module doing the work for me. However, this means my Region L4 list is separate to my other 3 levels in terms of parent-child relationship. This solution also produces a significant amount of sparsity. If anyone has a trick, I'd love to hear it. Thanks in advance.

ManjunathKN

Hi @CommunityMember113876 ,

Have you checked with combined list. its basically merging the 2 lists and making 1 list which also reduces the combinations which does not require.

https://community.anaplan.com/t5/On-Demand-Courses/Hierarchy-Design-and-Combination-Lists/ta-p/62086 

Thanks,
Manjunath