Hello,

I want to write a MDX Statement which will display the Member Key Column
Value and the Member Key Name Value. For Example: For Account Name leve
Member ky column is Account_Id and the Member Key Name is Account_Name.

Please help.

Thanks,
Manoj

I'm afraid you can't retrieve these properties with MDX.
These properties are AS-specific meta data, and as such, they are managed using DSO (Decision Support Objects).
You can use the DSO Level Inteface to access them.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html

Hi,

you can show those values by using member properties.
The KEY value is already a default member property, but for the name you'll
have to create it on AS.

then you can just call the value like this:
[Dimension].currentmember.properties("key")

Check under BOL for member properties.


Hope it helps!

Peace,
Andrej



"Manoj Joshi" <manoj (AT) opussoft (DOT) com> wrote