Skip to main content
B
BamaGirl
Newcomer
June 18, 2025
Question

Row Headers based on condition

  • June 18, 2025
  • 1 reply
  • 0 views

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 to UD1 in the same cube view, I then want to see the header as "Loading", "Unloading", etc., in the left most column where you see "Oper Expense". and not see the "Oper Expense"  at all even though I'll have the account in my POV.  The row header only allows you to have one header as Header 1. I'm thinking this is only possible with an XFBR String?  Has anyone else done this? If so, please share. Thanks....

 

1 reply

D
db_pdx
Contributor
June 18, 2025

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|)

 

B
BamaGirlAuthor
Newcomer
June 18, 2025

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.

 

D
db_pdx
Contributor
June 18, 2025

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#OperExpense

If 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|)

Terms & ConditionsAccessibility statement