Skip to main content
D
DRider
July 22, 2025
Question

Member expansion to show dimension hierarchy in reverse, except for base members?

  • July 22, 2025
  • 1 reply
  • 0 views

I'm building a cube view with the above requirements. It should should something like A#Net_Income.Tree, but in reverse and it should also exclude base members.

I've tried a few combinations like

  • A#Net_Income.TreeDescendantsInclusiveR.Where(HasChildren = True) (no results)
  • A#Net_Income.Tree.Where(HasChildren = True) (only shows top member)
  • A#Net_Income.ChildrenInclusiveR, A#Net_Income.Children.Children (wrong sort order)

I've also tried including the .Remove() function in a few different ways with no results. Manually specifying the base members is not an option.

I believe the issue is that the .Where(HasChildren = x) function is not compatible with the .tree expansion.

Has anyone built a report with these requirements that could guide me in the right direction?

Thanks in advance.

1 reply

R
RobbSalzmann
July 23, 2025

This looks like a bug to me. 

In GolfStream, 
A#[Income Statement].TreeDescendantsInclusiveR.Where(HasChildren = True) --> flat list of base members in reverse order
A#[Income Statement].TreeDescendantsInclusive.Where(HasChildren = True) --> flat list of base members in order

A#[Income Statement].TreeDescendantsInclusiveR.Where(HasChildren = False) --> flat list of base members in reverse order (Same as above)
A#[Income Statement].TreeDescendantsInclusive.Where(HasChildren = False) --> flat list of base members in order (Same as above)

A#[Income Statement].Tree.Where(HasChildren = True) --> No members returned.

Terms & ConditionsAccessibility statement