Forum Discussion

FM's avatar
FM
New Contributor III
3 years ago

Cube View formatting mixed dimensions

I have a Cube View that is displaying a single dimension in the first column (Departments), and a second dimension (Accounts) in the second column.   In order to match the formatting of th...
  • ChristianW's avatar
    3 years ago

    Use:

    UD1#Something:name(|MFAccount|) (or UD1#Something:name(|MFAccountDesc|))

    A#SomethingElse:name(|MFUD1|) (or A#SomethingElse:name(|MFUD1Desc|))

    where needed.

  • aricgresko's avatar
    3 years ago

    Christian's comment above should work and essentially what I'm going to add a little bit of extra color to.  I have a very similar use case to the example you provided. 

    I would only use Member Expansion 1 in your Rows.  If you use your Department dimension in Member Expansion 1 and your Account dimension in Nested Member Expansion 2, you'll have those two columns appear.

    Let's assume UD1 is Department in your case, I would recommend the following.

    For everything to the bolded Total row you showed, use the following: U1#TotalDepartment.base:A#OPEX:Name(|MFUD1Desc|)

    For everything below the bold, use the following: U1#TotalDepartment:A#OPEX.base:Name(|MFAccountDesc|)