I am looking for a possible solution. As of now, I am using SQL reporting services to create reports. The data is fetched from SQL server relational database by using stored procedure. Ours is an ASP.NET web app and so far, I have created a proper reporting engine which integrates seamlessly with reporting services. As most you know, as the reports get complex (say when it involves complicated summations etc), performance is getting a hit. To over come that, I was looking at Microsoft Analysis services (cubes). But, right now, I am kind of stuck. These are the points which really stop me from proceeding further.
1) I couldnt find enough materials in internet which talks about integrating analysis services with reporting services.
2) Is reporting services is the right front end tool for cubes?
3) Also, do I need to use SSIS or any ETL for porting the data from SQL relational database to cubes?
I am at the initial stage of my research and it could be helpful if you could give me right pointers to proceed.