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