Skip to main content
J
johnal67
December 16, 2024

Cubeview combining two dimensions in a header row/column

  • December 16, 2024
  • 1 reply
  • 1 view

I have a Cubeview that's Header rows are Entity/Account/UD2.  I'm going to export to excel, but currently I get column A is Entity, Column B is Account and Column C is UD2.

I'm trying to figure out if there is a way to make Column B be a concatenation of Account and UD2 when it's exported.  Column C can be whatever or not at all.

1 reply

P
Pete
December 17, 2024

Not sure I fully understand the setup of the cube view, but maybe try tagging it with ":Name(|MFAccount| - |MFUD2|)". If MF doesn't work, then the CVUD2 substitution variable may do it as well. 

J
johnal67Author
December 17, 2024

Thanks Pete, you were on it.  I found that as part of another discussion, and haven't updated this.  That worked somewhat, for some reason I get the UD2 Top member "Top_Dept" on every row though.  I think it maybe due to the expansion setting or something.

P
Pete
December 17, 2024

Gotcha, yeah probably something to do with the way it's being called. You would almost have to make individual rows for each intersection for it to work, which would be too much work, unless if it's only a handful of possibilities. There may be a technical solution to do this somehow, but I haven't come across that before. 

 

Terms & ConditionsAccessibility statement