The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
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...
Use:
UD1#Something:name(|MFAccount|) (or UD1#Something:name(|MFAccountDesc|))
A#SomethingElse:name(|MFUD1|) (or A#SomethingElse:name(|MFUD1Desc|))
where needed.
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|)
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|)
ChristianW, Thanks for explaining that in detail. I took your suggestions and applied them and it works as intended! Much appreciated!