Row Headers based on condition
I have a cube view similar to below. What I want to see is all the Accounts in the left most column like you see below and nothing where it says "Top" (not even the level where Top is). When I switch...
Forum Discussion
This should be possible with standard member filter functionality. One potential solution: drop the nested expansion keeping only Account in the row member filter. Then do member filter overrides.
A#RevOther,
A#RevSales,
A#OperExpense:U1#Loading:Name(|MFUD1Desc|),
A#OperExpense:U1#Unloading:Name(|MFUD1Desc|)
Thank you. I want to use .Base instead of loading every single base member like you have above. If you look at the screen shot I posted and then look at the one below, the one below is what I want.
Hmm, at least in my version (8.2) I am unable to format disparate expansions using any combination of name overrides and header overrides to achieve your expansions on both account and UD1 in the format you desire
A modification of my original proposal that gets close would be to switch the primary dimension to UD1 in the row block where you are defining the expansions and then applying the renaming to account. Meaning:
U1#Top:A#RevOther:Name(|MFAccountDesc|), U1#Top:A#RevSales:Name(|MFAccountDesc|), U1#ProcessType.Base:A#OperExpense, U1#ProcessRank.Base:A#OperExpenseIf you're on a higher version, you might play around with setting the 'Use Default Row Headers' to False, picking 1 dimension as the Header 1 Dimension Type and then testing different expansions with renames using :Name(|MFAccount|) or :Name(|MFUD1|)