Forum Discussion

Marco's avatar
Marco
Contributor II
7 days ago

GetBaseMembers: How can I perform a getmembers on an entity as if it were in a cube view?

Hi Everyone.

I wanted to see if there is a way to obtain the entities that are under another one but with a filter, like the following:

E#|!PerformPnL_Entity!|.TreeDescendantsInclusive.Where(Text1 StartsWith M_ and (HasChildren = True))

I want to do this in a BR, but I am not sure exactly how to do it or if it is possible, since GetBaseMembers brings all of them and I would like to filter it first so that there are not too many entities to verify.

I would appreciate it if you could help me with this question.

1 Reply

  • RobbSalzmann's avatar
    RobbSalzmann
    Valued Contributor II

    By using 'HasChildren = True' in your where function, you're filtering out all base members.  Base members by definition have no children.

    XBFR rules are ideal for meeting your requirement here.