Filter List Hierarchy of non-composite list in the UX

Hello!

I have found very gentle and beautiful solutions for filtering lists if they are composite ones, but i am struggling to build a filter for a-non composite list which has 5 levels of detalization.

Hierarchy looks like this:

And in Anaplan it looks like this (client does not want a composite list, he wants it in this way)

My goal is to be able to have a filter like in the picture below

Would be grateful for any ideas/help.

Thank you very much in advance!

Anton

Accepted answers

All comments

Amaya

Hi @tonybol ,

Please take a look at this.

This may help you.

Regards,

Taichi

LipChean_Soh

Hi @tonybol

I built something similar to @Amaya but i just added a bit more descriptions.

1. 'INP Select Level' is where you make your selection. Notice that 'SYS Ragged List.Display?' becomes TRUE accordingly.

1. A ragged list (non composite list) same with yours is built.

1. '1' is added to 'Final Level' because members such 'Revenue' and 'Costs' do not have parents.

2. Note that the summary method for all line items are 'Formula'.

3. And because the summary method for 'Display?' is also 'Formula', i cannot use LOOKUP to make this formula more dynamic than what you see, i.e.

INP Select Level.'L1?' AND Final Level = 1 OR INP Select Level.'L2?' AND Final Level = 2 OR INP Select Level.'L3?' AND Final Level = 3 OR INP Select Level.'L4?' AND Final Level = 4 OR INP Select Level.'L5?' AND Final Level = 5

1. Blueprint of 'INP Select Level'.

Please let your stakeholders know that while Ragged Hierarchies are more compact, a lot of workaround such as the one shown here is needed. Your stakeholders need to know the pros and cons of ragged vs composite hierarchies.

Thanks,

LipChean

Quick Links

Can you help?

Unanswered questions

How do i build a ragged hierarchy?
I have my dataset attached below
Dimensionality Issue
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
Formula to return Connection details...
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?