03-22-2023 04:40 AM
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.
03-22-2023 11:29 AM
Hi,
I'm not a expert in this area. But if you use A#MyMember.base don't work?
03-22-2023 12:06 PM
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 |
|
03-22-2023 02:10 PM
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.