Reporting Services + Analysis services Data Source

Hi all,

Till now all the reports for our application was created in Reporting Services 2005 with SQL Server Database(OLTP) stored procedures.

Most of the reports take 10 to 15 report Parameters and all are multi valued.

Now because of the slow response time,we have decided to use OLAP cubes data source. We have created the OLAP cube in Microsoft Analysis Services.

Can someone tell me how to use the report parameters to query the Cube.

Any links,books for reference would be of great help..

Thanks,

Looking forward to your replies

Hi there,

Try searching http://blogs.msdn.com.

Here is a link on how to use parameters.

http://www.databasejournal.com/features/mssql/article.php/10894_3504651_11

and here

http://blogs.msdn.com/bwelcker/archive/2005/04/24/411588.aspx

cheers,

Andrew

|||Thank you very much for replying.. i am looking at these sites.