List Modeling

jessehhhh

I have the following lists in a Hierarchy

Office L1

Clients L2

Funds L3

I also have 2 seperate lists

Entity

Location

In a module I am trying to show which entity and location that the Fund L3 rolls up into with boolean boxes but my problem is that a single funds can roll up into many Entity's and many locations

For exampl I want to show Fund ABC has entiry boxes checked for Entity DEF and HIJ as well as location boxes checked for KLM, NOP and QRS

Accepted answers

All comments

rob_marshall

Jessehhh,

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.

Hope this helps,

Rob

jessehhhh

How do I concatonate the codes?

Also if I do that wouldn't only one entity be able to the the parent or would that allow multiple entities to be a parent?

DavidSmith

@jessehhhh

It looks like you have a 1:many relationship for both Fund:Entity and Fund:Location

You haven't specified if Entity and Locations are independant, or have relationships, but I guess from your question that having a module dimensioned by Funds, Entity and Location is not practical

There are different ways to express this:

1. Using modules

You could have a module by Funds and Enties and another by Funds and Locations. You can then "tick" the relevent entries

2. Using numbered list hierarchies (as Rob mentioned)

You can also create hierarchies using Funds as a parent and then assign Entities as children (repeat for Locations)

3. Depending on the relationship between Entity and Location is might be possble to create a combined hierarchy with all three, but that could get a little complex to manage

If you can post the "downstream" requirements we may be able to refine the advice

David

jessehhhh

Thanks David,

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?

rob_marshall

Jessehhh,

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:

All Entities

Entity 123
- Fund ABC
- Fund DEF
Entity 234
- Fund ABC
- Fund GHI
Entity 456
- Fund DEF
- Fund GHI

For more information about creating hierarchies, I would suggest reviewing course 305: https://learning.anaplan.com/course/search.php?search=305

Thanks,

Rob

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…