I was trying to Use Analysis Cube in Reporting Services, but AdventureWorksDW is a OLTP database not OLAP in my Sql Server, to use it in reports I am trying to use the Data Provider Microsoft Sql Server Analysis Services as you mention in your book, while i going into the query designer to setup the KPI it is showing 'OLEDB-MD Error, Only text based query designer will be available'. what went wrong in my this report??

Both the relational data warehouse and the SSAS database have the same name. You will need to open the SSAS project that installed with the sample databases and the deploy and process the cube from BIDS. More details are at:
http://msftdbprodsamples.codeplex.com/

To verify that the databse exsits, open SSMS, connect to Analysis Services on your local machine and browse to the Adventure Works DW SSAS database. It contains a cube named Adventure Works.

__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access

I tried almost all MSI in that page which you mention no one is installing OLAP Database, I am using Windows 2003 Server with Sql Server 2008. I do not understand why the OLAP database is not getting installed on my system, any HINT?

Try looking for the project in:
C:\Program Files\Microsoft SQL Server\100\Tools\Samples\AdventureWorks Analysis Services Project

__________________
Paul Turley
Mentor | SQL Server MVP, SolidQ
Blog: sqlserverbiblog.com
Author: SQL Server Reporting Services Recipes for Designing Expert Reports; Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), SSIS, SSAS & Access

Thanks Mr. Paul Turley, I found the Analysis Project in your mentioned location, thanks for helping me again.