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.
Hi,
I'm not a expert in this area. But if you use A#MyMember.base don't work?
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.
