How to implement cube to ODS jump target reports

I have implemented a few reports against Analysis Services cubes in
reporting services. I have more detailed data contained in the cubes
in the underlying SQL datawarehouse. I have build a couple of reports
in RS against the datawarehouse tables as well. Now I want to link
these together some scenarios are in the cube I am storing data for
each product at a monthly level so if a user select a particular
product and month combination I want to trigger the reports against
the datawarehouse and pass the values like product# and month chosen
in the report against the cube to the report against the datawarehouse
to enable users to see all the data for the month at a more detailed
level.
Please can anybody share thoughts how this can be done in reporting
services. Currently we use Cognos reportnet we can do this we are
trying to migrate from Cognos reportnet to Reporting Services from a
standardisation and cost perspective.
Thanks
KarenAre you trying to link from AS cubes to RS reports through actions?
If you are looking at integrating AS 2000 and RS 2000, you may want to check
the following MSDN article about how to use RS URL access in AS actions:
http://msdn.microsoft.com/SQL/sqlwarehouse/ReportingServices/default.aspx?pull=/library/en-us/dnsql2k/html/olapasandrs.asp#olapasa_topic8
The good news is that setting up these actions and passing parameters will
be much easier in AS 2005 / RS 2005.
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Karen Middleton" <karenmiddleol@.yahoo.com> wrote in message
news:a5fd468a.0504050456.be5acfb@.posting.google.com...
>I have implemented a few reports against Analysis Services cubes in
> reporting services. I have more detailed data contained in the cubes
> in the underlying SQL datawarehouse. I have build a couple of reports
> in RS against the datawarehouse tables as well. Now I want to link
> these together some scenarios are in the cube I am storing data for
> each product at a monthly level so if a user select a particular
> product and month combination I want to trigger the reports against
> the datawarehouse and pass the values like product# and month chosen
> in the report against the cube to the report against the datawarehouse
> to enable users to see all the data for the month at a more detailed
> level.
> Please can anybody share thoughts how this can be done in reporting
> services. Currently we use Cognos reportnet we can do this we are
> trying to migrate from Cognos reportnet to Reporting Services from a
> standardisation and cost perspective.
>
> Thanks
> Karen|||Rob & Deepak
Thanks very much for the update. This was one of our pressing needs as
business
objects is asking the business to switch from reporting services to
Business Objects.
I must say the support in reporting services for Analysis Services at
this point
please note we are still on SQL 2000 is very limited. We are already
using Reporting
Services and constantly we face issues from people like Business
Objects who are
coming to our IT Managers and recommending to switch from Reporting
Services
to Crystal. Their justification is in Microsoft the reporting services
and
Analysis Services and the Excel teams refuse to talk to each other and
the product
be it Excel reporting or reporting services reporting lack integration
with
SQL & analysis services what Crystal can achieve.
We do not want to move from reporting services the competition
constantly goes to
the business with the story of lack of integration.
Thanks