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

tsequeira
New Contributor

Hi!

I have this cubeview with the filter member below

tsequeira_0-1724338711784.png

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

tsequeira_1-1724338824051.png

Someone can help me?

 

1 REPLY 1

CarlosAlvear
Contributor

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