Frequent Contributor

Mapping group

Hi team,


I have problem about mapping between entity, entiy(holding) and group.



entity H have transaction with entity G, but they in a different group (H in group 3, and G in group 2), we can elimination if H and G in a same group, but group 3 and group 2 in the same group 1, so how to create auto mapping using formula based on my case?


for detail i attached file



Community Boss

Re: Mapping group

You should have you groups as a hierarchy so you can probably tell that 3 and 2 belong to 1. you can do a LI eliminate:

parent(group entity G) = parent(group entity h)  

that will turn to a TRUE boolean when you can eliminate


It's even easier if you have set up a correct entity system module, you can refer directly to the top level of the hierarchy


Nathan Rudman, Anaplan Model Builder