Hi, I'am very new to Datawarehousing concepts of SQL2005, my current doubt is how to present the data to the end user from the cube i generated in Visual studio2005??? i had worked in cognos before and there we had a viewer file which was having the extension as .ppr and can be called from application which is connected to the Cube, so here i would like to know what is the next step after cube so that i can present the data... any help or links will be greatfull Mat
http://msdn2.microsoft.com/en-us/library/ms170208.aspx http://www.databasejournal.com/features/mssql/article.php/1550061 http://www.databasejournal.com/features/mssql/article.php/3553971 http://www.microsoft.com/sql/technologies/dm/default.mspx The above links should get you what you are looking in addition to the updated books online for SQL 2005.
Reporting Services is probably your best way to go here. Read up as much as you can about it. You will find that it is pretty easy to create reports using Visual Studio to present the data to your users. You can also embed Reporting Services Reports in another web application, if that is what you have to do.
Oh yes, SSRS with SSAS is best combination in such data warehousing environment. I'm still getting hands on with SSAS recently, its huge learning sea.