SSAS-Info.com - Microsoft SQL Server Analysis Services (SSAS) 2005/2008 resource hub
SSAS FAQ MDX FAQ MDX-How can I get attribute key with MDX
MDX-How can I get attribute key with MDX
User Rating: / 0
PoorBest 
Written by Ramunas Balukonis   
Monday, 11 June 2007 06:38

Q: How can I get attribute key with MDX

A:

To do so, use Member_Key function:

WITH
MEMBER Measures.ProductKey as [Product].[Product Categories].Currentmember.Member_Key
SELECT {Measures.ProductKey} ON axis(0),
[Product].[Product Categories].Members on axis(1)
FROM [Adventure Works]