Handling dummy levels in a Composite Hierarchy

Kalle

Hi Community!

 

I have a quite large organization hierarchy (12 levels) that I´ve converted from ragged to balanced. The original hierarchy has profit centers in every level, starting from level 4. So this means that I have had to create a lot of dummy levels to balance out the hierarchy. 

 

Example:

Hierarchy Level	Original	Balanced
L3	Country	Country
L4	Profit Center	Country L4
L5		Country L5
L6		Country L6
L7		Country L7
L8		Country L8
L9		Country L9
L10		Country L10
L11		Country L11
L12		Profit Center

 

This of course works fine but everything looks terrible and especially from an end user perspective it´s not ideal.

 

So I´d like to hear how are you handling large hierarchies that have been converted from ragged to balanced. Is there a way to filter the dummy levels? Are you using parallel hierarchies for reporting? 

 

Thanks,

- Kalle

Misbah

@Kalle 

 

In my case, I had an Org hierarchy which was 13 levels deep & was ragged. But what we discovered was that the Client was planning only at 4 levels. So we asked the client to pass that attribute with the ragged hierarchy and we converted the 13 level ragged hierarchy into 4 level balanced planning hierarchy. For reporting we had to use 13 level ragged hierarchy but there was not much reporting being done in Anaplan.

 

Just sharing this because if we can somehow do this, it saves a lot of space, easy to handle the model becomes scalable as well.

 

Thanks,

Misbah