Wrox Programmer Forums
|
BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2008 Reporting Services by Paul Turley, Thiago Silva, Bryan C. Smith, Ken Withee; ISBN: 9780470242018
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2008 Reporting Services ISBN: 978-0-470-24201-8 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 6th, 2009, 04:29 AM
Authorized User
 
Join Date: Aug 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Question Chapter 9 Reporting With Analysis Services.

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??
 
Old September 6th, 2009, 01:51 PM
Wrox Author
 
Join Date: May 2004
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old September 7th, 2009, 04:25 AM
Authorized User
 
Join Date: Aug 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Post SSAS 2008 OLAP Database

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?
 
Old September 7th, 2009, 04:33 AM
Wrox Author
 
Join Date: May 2004
Posts: 61
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old September 7th, 2009, 02:42 PM
Authorized User
 
Join Date: Aug 2009
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Thumbs up Found The Analysis Project

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
Do you use Analysis Services? valiko_work SQL Server 2005 0 August 10th, 2007 05:41 AM
Analysis Services Backup jemacc SQL Server 2000 0 November 15th, 2006 12:36 PM
Create setup for analysis,reporting services 2005 santoshkrmishra SQL Server 2005 0 August 18th, 2006 08:16 AM
Analysis Services + XP Pro perez SQL Server 2000 2 January 30th, 2006 10:22 PM
connect to Analysis Services with DTS ? toms SQL Server DTS 2 August 26th, 2004 08:43 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.