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