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 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.

3 Replies

  • tsequeira's avatar
    tsequeira
    New Contributor II
    3 years ago

    Hi,

    I'm not a expert in this area. But if you use A#MyMember.base don't work?

  • 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.