We have a ragged / unbalanced P&L hierarchy and want to expand to a specific level, for example at the simplest terms: starting at leaf level - call it level 0, we want to expand to say level 1?
In Dimension editor instructions: I have used the expand function 5 times, however by applying it this way, we land up at different node levels in the hierarchy. Including the leaf level for accounts with lesser levels than others (being ragged)
Results in inconsistencies in how we display our data - want to display only consolidations to a level above zero (leaf) at least.
Would be good if you could define the depth of levels for multiple parents
In Dimension editor instructions: I have used the expand function 5 times, however by applying it this way, we land up at different node levels in the hierarchy. Including the leaf level for accounts with lesser levels than others (being ragged)
Results in inconsistencies in how we display our data - want to display only consolidations to a level above zero (leaf) at least.
Would be good if you could define the depth of levels for multiple parents