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

[kmd]

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.  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?  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
     Child 2
        Child 3
            Base Member
Desired View (skip the Child3 parent):
Parent 1
      Child 2
            Base Member

[CarlosAlvear]

Hi there,

I think this can help you:

https://community.onestreamsoftware.com/t5/ONECommunity-Blog/Plant-a-Tree-in-your-Member-List/ba-p/2...

Best regards

[kmd]

Thanks very much for this.  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.  But thanks for your response to this 🙂