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
Marco
1 year agoContributor II
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
- RobbSalzmannValued 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.
Related Content
- 3 years ago
- 6 months ago
- 8 months ago
- 1 year ago