Ragged and Balanced Hierarchy help. Many to Many relationship with Ragged Hierarchy.

DaanishSoomar · July 2021

Hi Community,

I have been reviewing the knowledge around Ragged and Balanced hierarchy. I have a bit of a unique situation and need some help from the Community.

Attached is a file that breaks down the flat file I have put together of a relationship between entity-owner.

Each entity has an owner. That owner can also be an entity- and roll up to another owner. Eventually the hierarchy will reach the highest level which rolls up to the "ultimate" owner.

Is there a way for me to find automatically calculate what level each entity is on in the hierarchy in my flat list in the file? I.e. "B" is level 3, "D" is level 2, "F", is level 1. How would I go about calculating this in Anaplan?

I am working with a client that has no ETL tool available in their budget and all transformations will need to happen in Anaplan in the Data Hub.

See image below for visual representation (typo, the top "F", is supposed to be "G").

MicrosoftTeams-image (2).png

Misbah · July 2021

@DaanishSoomar

Have you watched this

Hub Model Hierarchy Management - Anaplan Community

Not only will this video help you understand how do you balance the ragged hierarchy but it will also walk you thru how do you calculate the level of each entity.

In your case I assume Owner can be considered as the Parent level of Entity.

Misbah

DaanishSoomar · July 2021

Yes I have watched the video. I am able to identify levels 1 and 2 but then stuck from level 3 onwards in my hierarchy.

Amaya · July 2021

Hi @DaanishSoomar ,

I think it would not be so hard to detect which level they are.

(Please see the attached excel.)

Level#.png

But implementing many-to-many relations with Anaplan will be challenging. Does it look like this?

I'd like to keep an eye on the challenge.
I look forward to seeing good practices emerge.

Regards,

Taichi

rob_marshall · July 2021

@DaanishSoomar

Take a look at this:

https://community.anaplan.com/pjakv59666/attachments/pjakv59666/forumsmisc/20886/1/Bill%20of%20Materials%20and%20Demand%20calculations.docx

Rob

DaanishSoomar · July 2021

Thanks everyone for the reading material and suggestions. These are very helpful. Coincidentally, another colleague of mine built a near replica model for the exact use case I'm after. He showed me a robust way to build a hierarchy, one that seemed counter-intuitive at first, but turned out to be ingenious.

I will work to put it together in a best practice article very soon. Some of the solutions here were relevant but not quite exactly what I was looking for.

DaanishSoomar · July 2021

Amaya, this is close, except I only know 1 owner. I do not know 3 owners, they cannot be blue cells, they have to be calculated.

Monpero · April 2023

Hi @Misbah and @rob_marshall the link you guys sent does not work, please could you guys provide a different one to the links?. It will be really helpful for us to have a read through.

Thanks.