I need to rename dimension headers in the result table for example I can change measure names like following:
WITH Member x AS [Measures].[Num of Project]
SELECT
NON Empty {x} ON COLUMNS,
NON Empty {[DimensionName].[HierarchyName].[LevelName]} on ROWS
FROM [CubeName]
And this MDX Query return a table as a result in Analysis Server's interface like that:
|---------------------|------------------|
| LevelName | x |
|---------------------|------------------|
| Member 1 | 34 |
|---------------------|------------------|
| Member 2 | 12 |
|---------------------|------------------|
.
.
.
But I have to rename the displayed dimension's level names for example I want to rename 'LevelName' to 'Level 1' as displayed name in table headers. I tried the following MDX Query:
WITH Member x AS [Measures].[Num of Project]
SELECT
NON Empty {x} ON COLUMNS,
NON Empty {[DimensionName].[HierarchyName].[LevelName]} as [Level 1] on ROWS
FROM [CubeName]
But it neither works nor excepts the error. 'LevelName' is still displayed in table header, not 'Level 1'. I need that in Adomd Connection to distinguish dimensions from each other for some calculations. I coudn't find any answer in anywhere. I am new in MDX, I hope that I can explain my problem clearly.