SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Drillthrough from cube to ssrs report
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

aravula
Starting Member

5 Posts

Posted - 10/07/2013 :  09:13:37  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 10/08/2013 :  00:18:44  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

aravula
Starting Member

5 Posts

Posted - 10/08/2013 :  09:30:13  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 10/08/2013 :  09:39:55  Show Profile  Reply with Quote
nope...i was suggesting using excel based on cube source to explore cube data. then action would be available inside excel

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

aravula
Starting Member

5 Posts

Posted - 10/08/2013 :  12:16:55  Show Profile  Reply with Quote
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.)
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 10/08/2013 :  13:27:51  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000