Drill through from Analysis Studio to Relational data in Report Studio

[buzz73]

Hi,
I have big problems to make a drill through functionality to work.
I have created a report in Analysis Studio, which uses a SSAS cube.
The target report is a list report using a Relational data with a parameter [Produktgruppsbeskrivning] =  ?p_Produktgruppbesk?

I have created a drill-through definition and given the parameter a value from the cube.
But the drill through doesn´t work. I can imagin that the parameter value is not matching the relational value, since I am using a SSAS cube.

Have anyone any ideas what I can do to make the parameter value (from the cube) match the relational data value?

Best regards,
Maria

[MFGF]

Hi Maria,

One thing that can cause issues is the fact that reports and analyses from OLAP sources such as MSAS are based on members from the cube. Each member will have an identifier and a caption. Your reports will display the caption of each member, but when you come to drill through it is the ID of the member that is passed by default.

From the name of your item, it looks like you are filtering on Product Description in your target report, and assuming that the Product Description (ie the caption of the Product Member) is baing passed?  An easy change would be to modify your filter on the target report to filter on Product Code, and see if this fixes your problem. You can also find a specific product member in your package tree and right-click on it, then select Properties. Locate the MUN (Member Unique Name) and look at the very last part of it - this will be the value that is passed to your relational report by default.

Regards,

MF.

[buzz73]

Hi,
Thank you for your answer and I changed the filter in my target report to productgroup nr and it worked fine.
/ Maria