-
Changing Column and Row Heading
I am trying to change the row and column heading to make it more meaningful in MDX.
For example instead of showing the_actual_cost, i want to show cost. This is done easily in SQL like
SELECT the_actual_cost AS cost......
Any help will be greatly appreciated.
Thanks
Mahesh
-
Hi Mahesh,
You can do this using
With
Member [Measures].[cost] AS '[Measures].[the_actual_cost]'
Select
{
[Measures].[cost]
} on columns
from [Cube]
Let me know if this is what you expected.
Bye
Sumit Pilankar
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|