Cube View formatting mixed dimensions
- 3 years ago
Use:
UD1#Something:name(|MFAccount|) (or UD1#Something:name(|MFAccountDesc|))
A#SomethingElse:name(|MFUD1|) (or A#SomethingElse:name(|MFUD1Desc|))
where needed.
- 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|)