Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aravula
Starting Member
5 Posts |
 Posted - 2013-10-07 : 09:13:37
|
| 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 is 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. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-08 : 00:18:44
|
| you can use end used tool like Excel to create a connection to the cube. then the action defined would be available from the cube cells selected in the end user tool.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
aravula
Starting Member
5 Posts |
Posted - 2013-10-08 : 09:30:13
|
| Thank you for the reply. We want users to use reports from only report server url. So it is not possible for us to use excel as the report source. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-08 : 09:39:55
|
| nope...i was suggesting using excel based on cube source to explore cube data. then action would be available inside excel------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
aravula
Starting Member
5 Posts |
Posted - 2013-10-08 : 12:16:55
|
| I understood your suggestion. But users want a simple report where they can just check when we give them the Reportserver url. If we ask them to use a excel and create report using a cube they will not agree.Do you know whether we can pass the parameters which we use in summary report to detail report?(Not the fields as parameters, I want to pass actual parameters which we use in summary report.) |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-08 : 13:27:51
|
| you can do that in SSRS. Its called jump to report which will enable you to navigate from one report to other and even pass some parameters.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Drillthrough from cube to ssrs report