Hi all,

How can I give Column alias in MDX. For
Example I have a column [Measures].[Avg1002growth]. How can i change
[Measures].[Avg1002growth] column name to an understandable name. ( like
'as' in Sql , [Measures].[Avg1002growth] as [Average Revenue]).


Thanks in advance

Subin

Hi Subin,

you can declare own members at the beginnig of mdx statement.

Here a little example:

with member [Measures].[My own name for Sales] as '([Measures].[Store
Sales])'
select
{[Measures].[My own name for Sales]} on columns,
{[Product].[Product Department].members} on rows
from Sales

Gerhard


"Subin" <Subin (AT) discussions (DOT) microsoft.com> schrieb im Newsbeitrag
news:1CDB4181-0F10-4BE1-BF7D-0B1365F5C9A1 (AT) microsoft (DOT) com...