Forum Discussion

BamaGirl's avatar
BamaGirl
New Contributor II
7 days ago

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

 

Cube View

3 Replies

  • db_pdx's avatar
    db_pdx
    Valued Contributor
    7 days ago

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

     

    • BamaGirl's avatar
      BamaGirl
      New Contributor II
      7 days ago

      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.

       

      • db_pdx's avatar
        db_pdx
        Valued Contributor
        7 days ago

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