Hi,

I want to get both the Member Name & the Member key for each dimension
in the MDX Query.

This way, i can use the Member name for display purposes. And use Member Key
as a parameter (query string) in the link to drill down.

Is there a way to do this?

Thanks,

Sam

Sure. In MDX syntax, you reference a key using the & character.
From Foodmart:

select
{[Measures].[Avg Salary]} on columns,
{[Employees].[All Employees].[Sheri Nowmer].Children} on rows
from HR
and

select
{[Measures].[Avg Salary]} on columns,
{[Employees].[All Employees].&[1].Children} on rows
from HR

Return the same values since Sheri's member key is 1.

Hope that helps.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote

Hi Dave,

My question is liitle bit different.

I want to see both the Key and the name in the same MDX Statement.

Example:

Name - ID - Billed Amount
---------- ---- ----------------
North East - 'NE' - 12000
SouthWest- 'SW' - 28000
MidAtlantic- 'MA' - 45000

In my Geography Dimension ' North East' is the Member Name (Description) &
NE is the Member Key.

Why i want like this is, i want to use 'North East' for display purpose &
'NE' to pass it as a link to the URL fo rdrill down.

Hopefully this time i am clear of what i want.

Best Regards,

Sam.


"Dave Wickert [MSFT]" wrote:

The key is available as a property of a member in MDX.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Prasad" <Prasad (AT) discussions (DOT) microsoft.com> wrote