Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

SSRS – Creating Drill Through reports with MDX

  • 10 February 2014
  • Author: MikeDavis
  • Number of views: 3558
  • 0 Comments

If you are reporting from a Cube in SSRS and you want to drill through to another report you can set up actions just like any other drill through except one small change. The parameter you pass to the drill through report must be changed to Unique Name instead of value.

clip_image001

Go to the detailed report that you are drilling down to and right click on the datasets folder then select show hidden data sets so you can see the parameter dataset. In this query you will see the key under the parameter value. This is the unique value that the report needs to receive. Changing the parameter to unique name takes care of this issue.

clip_image002


Print
Categories: Big Data
Tags:
Rate this article:
No rating
MikeDavis

MikeDavisMikeDavis

Other posts by MikeDavis

Please login or register to post comments.