Hi,

Is there any way we assign Alias Name in MDX Qry ..for example
select
{ [Measures].[Units Shipped} on columns,
NON EMPTY [Store].[Store Name].members on rows
from Warehouse

Now I would like to assign alias name for
{ [Measures].[Units Shipped] } as Units

select
{ [Measures].[Units Shipped]} as Units on columns,
NON EMPTY [Store].[Store Name].members on rows
from Warehouse

Thanks
-Kris

MDX does not have the concept of an alias like SQL does. What you could
do in this particular situation is to create a query scope calculated
measure with the name you want that simply returns the underlying
measure.

eg.

WITH
MEMBER Measures.[Units] as '[Measures].[Units Shipped]'
select
{ [Measures].[Units]} on columns,
NON EMPTY [Store].[Store Name].members on rows
from Warehouse

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <9E2770D7-D722-4947-9602-EBA1D79EE748 (AT) microsoft (DOT) com>,
Kris (AT) discussions (DOT) microsoft.com says...