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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics