The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
10 months ago

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

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.

Cube View
Reports

1 Reply

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II
    10 months ago

    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.