the title pretty much says it all. I have a cube with data in it and I have yet to find a way to change the column names.
They appear in a very ugly manner like [cubeName].[$dimension.columnName]. I have tried everything I know and anything I found on the web but nothing seems to be working.
What I tried to do in most cases is create an Action in the Actions tab and write some MDX query language in there. No results whatsoever. As if the action is never run.
Does anyone know how to do this? I've spent about 3 days trying to figure this out. Thank you.
ASSP (Analysis Services Stored Procedures) on CodePlex can do this.
http://asstoredprocedures.codeplex.com/wikipage?title=Drillthrough
Looks like it may not work well with Excel, due to the multi-selects and the way Excel/SSAS interact. Worth a look though.