Handling dummy levels in a Composite Hierarchy
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.
|L4||Profit Center||Country L4|
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?