Conditional Parenting
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.
Answers
-
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,
Manjunath0
