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

Filip's avatar
Filip
New Contributor II
3 years ago

Can't get HasChildren to work in CV

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 ...
Filip's avatar
Filip
New Contributor II
3 years ago

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

 

 

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    3 years ago

    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.