Skip to main content
K
kmd
January 15, 2024

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

  • January 15, 2024
  • 1 reply
  • 0 views

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

1 reply

C
CarlosAlvear
January 15, 2024

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

K
kmdAuthor
January 16, 2024

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 ðŸ™‚

Terms & ConditionsAccessibility statement