Wednesday, 2 December 2015

MDX Drill through issue

MDX parameter in drill through passes values like 15 - MILK but report works with [Product].[Product].[Department No].&[258]. To resolve this issue add  
WITH MEMBER [Label] AS '[Department No]. CURRENTMEMBER.UNIQUENAME ' at the start of the code.
Then add [Measures].[Label] in your Axis(0)

Then in drill through action tab pass [Label} for your parameter