Export to Excel cubeview with column header filled with the dimension name

[tsequeira]

Hi!

I have this cubeview with the filter member below

When I export to Excel, I would like have the columns header filled with the dimension name "Entity" and "Consolidation"

Someone can help me?

[CarlosAlvear]

Hi,

It's not exactly what you require but it can do the job. You can put a blank row and then add names as you prefer. For instance;

E#None:Name([YourEntityDimensionName])

C#Local:Name([Consolidation])

Good luck,

Regards,

Carlos