SSRS Drillthrough for SSAS cubes, how to pass a parameter to an MDX dataset
Yesterday I had a chat with my boss about drillthrough reports. I told him that with SSRS 2008 it can be done easily. Yep, I was right in terms of a SQL Server data source (or other relational I presume) but it cost me almost a day to figure out how to do it if you have two reports based on an SSAS OLAP cube!
The usual method does not work because you cannot pass a parameter like in the SQL way. No, MDX is much different. Forget the multidimensional query designer because though it’s useable in case of a simple parameterized report but it just makes things messy in our case (it’s just my opinion and experience). I’m just at very beginner in MDX that’s one reason I suffered so much with this issue.
Based on the Adventure Works DW 2008 SSAS database (available on Codeplex such as the underlying SQL Server database) I created an example.
Tags: ssrs, drillthrough