Forum Discussion

DDrider's avatar
DDrider
New Contributor III
10 days 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 days 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.