I have the following MDX query:

Select {Plant.Members} on Rows,
{Period.Members} on Columns

When I run this query I get the Plant description like the following:

Danbury Conversion Plant but for the Plant dimension the key is PlantID
which is the member property and the plant ID for this is - DI01.

I want DI01 to be reported than the text Danbury Conversion Plant.

Please clarify how I can fix this to report the property PlantId.

Thanks
Karen

just to clarify, your dimension [Plant] currently returns "Danbury
Conversion Plant", but you want it to return the member property of PlantID,
which is "DI01".

You could always rebuild your dimension such that the dimesion members of
the [Plant] dimension is actually the ID instead of the description (the
field that contains "Danbury Conversion Plant"). Another approach is to use
the member properties function within MDX - it would be something like:

[Plant].member.properties("PlantID")

But note that many UIs are not able to return the member property field .
If you are building your own UI, you should be okay as you can indicate in
ADO/MD to return the member properties field as well.

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



<karenmiddleol (AT) yahoo (DOT) com> wrote

Denny is right, not many UIs are able to deal with member properties.
Another possible hack if you don't want to change your dimension is to
include a calculated member in the column set.

eg.

WITH
MEMBER Period.PlantID as '[Plant].CurrentMember.Properties("Key")'
Select {Plant.Members} on Rows,
{Period.PlantID, Period.Members} on Columns
From [Inv]
Where [Measures].[Qty]

Note that some UIs don't like string in cells either, but more of handle
them than they do member properties.

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

In article <#tI63U12FHA.2552 (AT) TK2MSFTNGP10 (DOT) phx.gbl>,
dennyglee (AT) hotmail (DOT) com says...

oh yeah, I forgot about that one, that one's cool :-)

--
HTH!
Denny Lee
<dennyglee_at_hotmail_dot_com>

Blog at:: http://spaces.msn.com/members/denster/



"Darren Gosbell" <xxx (AT) xxx (DOT) com> wrote