Is it possible to skip a level using a Member Expansion?

Question

Hi all,
I'm looking for a way to skip a dimension parent level in a Tree expansion while still maintaining a tree style view.&nbsp; Does anyone know if this is possible?
Alternatively, does anyone know of a way to declare an expansion MyHierarchy.Tree and include a .Where or .Remove clause?&nbsp; I can't seem to get this to work for me so I wonder if it's just not possible using the "Tree" method.
Example:
Default Expansion based on .Tree expansion
Parent 1&nbsp; &nbsp; &nbsp;Child 2&nbsp; &nbsp; &nbsp; &nbsp; Child 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Base MemberDesired View (skip the Child3 parent):Parent 1&nbsp; &nbsp; &nbsp; Child 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Base Member

CarlosAlvear · Answer

Hi there,
I think this can help you:
https://community.onestreamsoftware.com/t5/ONECommunity-Blog/Plant-a-Tree-in-your-Member-List/ba-p/22344
Best regards

kmd · Answer

Thanks very much for this.&nbsp; I was hoping there was an alternative to list building however and that someone had figured out how to use the Tree expansion where one could include a remove() or where() clause.&nbsp; But thanks for your response to this&nbsp;🙂

Forum Discussion

Is it possible to skip a level using a Member Expansion?

Related Content

Is possible to use member expansion in a combined POV?

Formatting for different member expansions

CubeView Member Expansion based on 'AllowInput=True'

Cubeviews - Add blanks between Member expansions

Question: Is it possible to loop through members within confirmation rules?