Using Alias in MDX queries

#1

What is the symtax for retireving members from a
mulitdimensional cube by providinf aliases. For examle if
I want to retrieve the measure [Total Sales] as 'Sales'
how should I change the MDX query to achive the above.

#2

The only way to alias a member is by creating a calculated member...

WITH MEMBER Measures.[Sales] AS
' Measures.[Total Sales] '

tom @ the domain below
www.tomchester.net

"S S" <simi_suk (AT) yahoo (DOT) com> wrote

Quote:

What is the symtax for retireving members from a
mulitdimensional cube by providinf aliases. For examle if
I want to retrieve the measure [Total Sales] as 'Sales'
how should I change the MDX query to achive the above.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using Alias in MDX queries

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Using Alias in MDX queries - 10-21-2003 , 05:07 AM

Re: Using Alias in MDX queries - 10-21-2003 , 12:16 PM