Buy Used
CDN$ 0.99
+ CDN$ 6.49 shipping
Used: Good | Details
Condition: Used: Good
Comment: Good Condition **SHIPPED FROM UK** We believe you will be completely satisfied with our quick and reliable service. All orders are dispatched as swiftly as possible! Buy with confidence!
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Professional SQL Server Analysis Services 2005 with MDX Paperback – May 30 2006

2.0 out of 5 stars 1 customer review

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
CDN$ 89.56 CDN$ 0.99

Harry Potter Book Boutique
click to open popover

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Product Details

  • Paperback: 864 pages
  • Publisher: Wrox; 1 edition (May 30 2006)
  • Language: English
  • ISBN-10: 0764579185
  • ISBN-13: 978-0764579189
  • Product Dimensions: 18.8 x 4.7 x 23.6 cm
  • Shipping Weight: 1.3 Kg
  • Average Customer Review: 2.0 out of 5 stars 1 customer review
  • Amazon Bestsellers Rank: #2,123,921 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

From the Back Cover

SQL Server Analysis Services 2005 provides you with the business intelligence platform needed to build full-scale, multidimensional databases. MDX is the query language used to extract information from those multidimensional databases. Analysis Services 2005 supports core business functions such as market analysis, budgeting and forecasting.

Written by members of the Analysis Services product team at Microsoft, this timely and authoritative book shows you how to use Analysis Services along with SQL Server components like Integration Services, Data Mining, and Reporting Services to provide comprehensive, end-to-end solutions. Ultimately you'll learn to solve business problems by leveraging all the tools that SQL Server 2005 has to offer.

What you will learn from this book

  • The development process for designing Unified Dimensional Models (UDM)
  • Using to MDX to query databases and for sophicticated business analysis
  • How to harness features such as multiple measure groups, BI wizards, Key performance indicators, and Actions
  • How to integrate Analysis Services with other SQL Server 2005 components in order to provide the best possible end-to-end solutions
  • How to manage and secure Analysis Services efficiently in support of your BI users
  • How to optimize your design and/or scale Analysis Services to extract the best performance

Who this book is for

This book is for database and data warehouse developers and administrators interested in exploiting the power of BI and leveraging the SQL Server 2005 tool set.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

About the Author

Sivakumar Harinath was born in Chennai, India. Siva has a Ph.D. in Computer Science from the University of Illinois at Chicago. His thesis title was: “Data Management Support for Distributed Data Mining of Large Datasets over High Speed Wide Area Networks.” Siva has worked for Newgen Software Technologies (P) Ltd., IBM Toronto Labs, Canada, and has been at Microsoft since February of 2002. Siva started as a Software Design Engineer in Test (SDET) in the Analysis Services Performance Team and is currently an SDET Lead for Analysis Services 2005. Siva’s other interests include high performance computing, distributed systems and high speed networking. Siva is married to Shreepriya and had twins Praveen and Divya during the course of writing this book. His personal interests include travel, games/sports (in particular, Chess, Carrom, Racquet Ball, Board games) and Cooking. You can reach Siva at

Stephen Quinn was born in San Luis Obispo, California. Stephen has a Masters degree (1988) in Cognitive Psychology from California State University, Chico and is scheduled to receive his Masters of Business Administration (MBA) from the University of Washington, Seattle, in June 2006. Stephen is married to Katherine and is raising his daughter, Anastasia. He has been in most roles common to the R&D environment i.e., software developer, technical writer, technical support specialist and several quality assurance roles. Stephen has published some 20 articles in the magazines Byte, InfoWorld and Datamation. With 15+ years of software experience; Stephen has worked the last 8 years at Microsoft; most recently as a Technical Writer in SQL User Education and before that, for several years as Test Manager in the SQL Business Intelligence Unit. You can reach Stephen at

Customer Reviews

2.0 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See the customer review
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
This is my first wrox book. I'm not sure if they are all like this, or just this one.

I bought this book and began reading it with a positive outlook. The writers seem genuinely nice, and they were senior developers of the product. I liked their sense of humour, and looked forward to becoming competent at what I believe to be an excellent product.

Sadly, the book is riddled with errors--obvious errors and not-so-obvious errors. The latter, of course, are killers. Pretty well every code fragment is broken, either through typos, or because the syntax doesn't match the sample database. Thankfully, you can download code examples that have been corrected. But you can't download corrected text. The errata are scant, and the publisher ignores submissions of corrections (not just mine, but others -- see the reviews on American amazon).

When I say "riddled with errors", I mean several per page, typically. It is clear that this book was not usage tested, or it was only tested on those familiar wtih SQL Server, Visual Studio, and also perhaps Analysis Services 2000. I'm new to all these, but I'm a bright enough boy. :-)

Now. If you are self-sufficient and very talented, you can puzzle your way through. I don't know SQL Server and still managed to learn the Attach command needed to complete installation of the sample database.

Also I have learned much because of errors and omissions. For example, I learned the hard way that I can't create an object in one tab (of SQL Server Management Studio) and reference it from another tab. Mind you, that took me a few hours, whereas one sentence in the book would have taught me just as well. This is one of hundreds of omissions.

By no means should you use this book to learn MDX.
Read more ›
One person found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again.
Report abuse

Most Helpful Customer Reviews on (beta) HASH(0xa73b3528) out of 5 stars 11 reviews
25 of 27 people found the following review helpful
HASH(0xa71b19b4) out of 5 stars Great Book Aug. 31 2006
By K. Griffiths - Published on
Format: Paperback Verified Purchase
I needed to know quickly how to implement a BI solution and ordered three books: Delivering Business Intelligence with Microsoft SQL Server 2005 by Brian Larsen, Applied Microsoft Analysis Services by Teo Lachev, and this book. Of the tree books, this is the only one I really needed. This book had everything I wanted to know about Analysis Services. I was also impressed with the knowledge and information regarding how to design dimensions and cubes especially when it comes to tough situations such as how to apply security. If you need to implement a BI solution, I highly recommend this book.
12 of 12 people found the following review helpful
HASH(0xa7d1e2dc) out of 5 stars What a mess March 18 2007
By L. Van Staalduinen - Published on
Format: Paperback
I do not understand why this book gets such high ratings by other readers. I found this book a real mess. My concise evaluation of "Professional SQL Server Analysis Services 2005 with MDX":

· general: bad as a tutorial, but it might serve as a good reference,

· incorrect code: see below,

· incorrect references to other chapters,

· extremely inconsistent use of names of the cube, tables, dimensions, measures, etc., which makes the learning process more like a puzzle,

· subjects, details are scattered over many chapters (which has some advantages as well), but complicates the learning process.

In chapter 3 of this book it starts with code samples, that are incorrect in almost any sense. Not really being a novice, but having my first experience with SSAS (that is: the 2005 version, I had some experience with the 2000 predecessor), I was blaming my ignorance. I could better do not: I simply had to correct about every code sample.

I made a long list of errata, that I have sent to Wiley/Wrox on January 9, 2007. These errata are very detailed and specific, but I do not find the results in the list of errata of this book on the Wiley or Wrox site. They simply did not process my errata.

So, I finally bought "Microsoft SQL Server 2005 Analysis Services" by Melomed, (Sams, 2007). My first impression: very good, indeed. I just have it for two days now, so my review will take a few more months.

10 of 12 people found the following review helpful
HASH(0xa7898f54) out of 5 stars An absolute must for business intelligence.... Aug. 22 2006
By D. Gresty - Published on
Format: Paperback
I have over 9 years of database experience, with about 4 years in MS Data Warehousing experience which included Reporting Services and DTS.

With the major improvements made with SQL Server 2005, this book allowed me to create a TOTAL business intelligence system which included SSIS, Analysis Services, MDX and Reporting. The book is easy to read and contains valuable information that I haven't seen in other books.

I know following the information in this book is that the client received a top notch system from beginning to the end.
3 of 3 people found the following review helpful
HASH(0xa70fff24) out of 5 stars Excellent tutorial on SSAS 2005 Dec 22 2007
By Vladimir Kievsky - Published on
Format: Paperback
I am a DBA, and bought this book hoping to learn quickly basics of implementing SSAS project. This book exceeded all my expectations. I would call it a practical tutorial on implementation with explanation of all aspects behind SSAS: basic theory, technologies, tools, security, connectivity. Not only it gives you hands-on approach to learning with 99.9% precision in samples, but also explains usage of Microsoft SQL Server 2005's related technologies: Integrated Services, Reporting Services.
The scope of presenation is also very much oriented on practical needs of SSAS utilization.
In short, I am 110% satisfied on my expectations for this book.

Vladimir Kievsky
2 of 2 people found the following review helpful
HASH(0xa71c7e7c) out of 5 stars Good Cop / Bad Cop April 18 2008
By Dan Zeltner - Published on
Format: Paperback
Half of the chapters in this book are well planned and very readable. But the other half are just terrible. There are two authors of this book, so it's clear what is behind this. The "bad" chapters are loaded with bad grammar, technical errors and explanations that just don't make sense. This would be bad enough, but the larger problem is that there is no overall planning to these chapters, with illogical jumps between topics and a lack of any conceptual flow. I've been reading technical books for over 25 years, and this is without a doubt the poorest offering I've ever seen published. You can gain some value from the book from the "good" chapters, but the other chapters are so frustrating that I recommend avoiding this book altogether. If you need to ramp up on 2005 Analysis Services, the Microsoft Press Step-by-Step book is a much better choice.