How to access multiple column Key in report based on MDX
There is a report based on MDX statement. This statement has MEMBER_KEY within DIMENSION PROPERTIES clause, so keys are retrieved. However expression =Fields!Month.Key where Month is a dimension attribute, which has a 2 columns key, always returns
an empty string. I also tried =Fields!Month.Key(0) and =Fields!Month.Key(1) in my attempt to extract 2 values separately. That did not work either, returns an error.
It would be ineteresting to note that this works good for attributes, which have a single column key - the correct value is returned.
So how to get the values, which represent a multiple column Key?
August 23rd, 2011 3:36pm
Hi Dmitry Otblesk,
As a workaround to retrieve multiple column key separately, I suggest you to get them respectively in the dataset query, like
with
member Measures.key1 as [Customer].[State-Province].currentmember.Properties("Key0")
member Measures.key2 as [Customer].[State-Province].currentmember.Properties("Key1")
select {Measures.key1,Measures.key2}
on 0,
[Customer].[State-Province].[State-Province] on 1
from [Adventure Works]
And then, drag the fields
Key0 and Key1 to corresponding tablix filed.
More details about MDX Properties function, please refer:
http://msdn.microsoft.com/en-us/library/ms144821(v=SQL.110).aspx
Thanks,
Lola
Please remember to mark the replies as answers if they help.
Free Windows Admin Tool Kit Click here and download it now
August 26th, 2011 4:16am
Yes, this really works.
Thanks!
August 26th, 2011 10:44am