Have you thought about using a Numbered List with the Entity as the parent with the funds? A numbered list allows for this ability, but just make sure your code is concatenated with the parent. For example, same the Code of Entity is 100 and the Code for Fund is ABC, your code for the numbered list would be 100_ABC. This way, the fund can have roll up to different parents, but at the same time, keeping the code unique.
Fund and Entity are both independent. My end goal is to be able to bring this into a module and permission people to be able to see specfic funds based on the entity and or location.
I like the idea of having a number list with Location flowing into Funds and then a seperate list with Entity flowing into funds as this would allow multiple entitys and locations to be associated with a particular fund.
I am new to anaplan so I don't know many of these things but im assuming id then be able to bring that information into a module and create boolean boxes for each location and entity and that checked off if there is a child (parent or entity) associated with a fund. Or would there be a better way of doing this?
How do you define which Fund rolls up to an Entity or Location? Is it part of the transactional data or is a user defining it by the Assign Function?
I ask the above because it will then tell you how to create the hierarchy. If it is by the transactional data, you would concatenate the code of Entity with the code of Fund with an "_" in between. Then you can create an action which will populate the list. So, your result could be the following: