Forum Discussion

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