- OneStream Community
- Forums
- Reporting
- Can't get HasChildren to work in CV
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Can't get HasChildren to work in CV
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 04:40 AM
Hi,
Grateful for help.
I am trying to expand a member in the Account dimension. I want to expand all children that are base members.
A#MyMember.Children.Where(HasChildren = False)
Above is the formula I am using, but it doesn't work. If I enter False, then all accounts are shown (even calulated members/parents) and if I enter True then all rows are suppressed, I get no result at all.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 11:29 AM
Hi,
I'm not a expert in this area. But if you use A#MyMember.base don't work?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 12:06 PM
Hi,
I cant use base because I dont want all base accounts.
See table below.
Account A is MyMember. But I only want to show account Y and Z. Account X has children (1 and 2) so if I choose base I will also get account 1 and account 2.
| Account A | ||
| Account X | ||
| Account 1 | ||
| Account 2 | ||
| Account Y | ||
| Account Z |
|
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-22-2023 02:10 PM
Strange, the accounts (Y & Z) have data in them, correct? Additionally, your suppression settings are on/off according to your needs? A#MyMember.Children.Where(HasChildren = False) works for me exactly as you are hoping for.
