Pulling Key instead of Caption

Last Post 02 Mar 2005 08:01 PM by Alan_SQL. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Alan_SQL
New Member
New Member

--
02 Mar 2005 08:01 PM
I currently have this MDX query which pulls the description\caption of the dimension level. But I would like it to display the key values for the dimension instead.

SELECT
NON EMPTY
{ [Measures].[Member Count] }
ON COLUMNS ,

NON EMPTY

{{
{ DESCENDANTS( [Customer].[Customer Status].[Active], [Customer].[Customer Group] ) }
* { DESCENDANTS( [Product].[All Product], [Product].[Product]) }
* { DESCENDANTS( [Program Stat].[Suit], [Program Stat].[Level 04] ) }
}}

ON ROWS

FROM [Status History]

WHERE ( [Time].[By Month].[Day].&[20041031])

Your assistance is very much appreciated.

Thanks,

Alan


Acceptable Use Policy
---