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