Drill Through from ssas to ssrs

Question

Post reply

Drill Through from ssas to ssrs

aravula1

SSC Enthusiast

Points: 174
More actions
October 7, 2013 at 7:21 am

#146205

Hi, I tried ReportAction in SSAS and tried to drillthrough to a ssrs report. But my question is how can users use cube in frontend? do we need to create a report with that cube and publish to ReportServer? Or there any way where I can drill through from a summary report to drill through report where summary report has lot of parameters and only one dimension and 2 measures. We need to pass the parameters which we select in summary report to detail Report.
Any help is appreciated.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

You can create Actions in the SSRS report for this feature.

http://www.katieandemil.com/ssrs-action-go-to-report-with-parameters-drill-down-example

Raunak J

Koen Verbeeck SSC Guru Points: 259125 More actions · Answer 2

aravula1 (10/7/2013)
Hi, I tried ReportAction in SSAS and tried to drillthrough to a ssrs report. But my question is how can users use cube in frontend? do we need to create a report with that cube and publish to ReportServer? Or there any way where I can drill through from a summary report to drill through report where summary report has lot of parameters and only one dimension and 2 measures. We need to pass the parameters which we select in summary report to detail Report.
Any help is appreciated.

You can either build a report action in SSAS like Raunak mentioned, which means the front end is Excel. In the Excel PivotTable, you can right-click on a cell and choose the appropriate action.

Create a Reporting Action, using SQL Server Analysis Services (SSAS) 2012 Cube Designer

Or you do everything in SSRS: you build the parent report, and you create a drillthrough to a child report in which you pass parameters along to the child report.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

aravula1 SSC Enthusiast Points: 174 More actions · Answer 3

Thank you for your replies. I created master and detail reports in ssrs using ssas cube as datasource and passed the parameters. It is working after a lot of struggle.