Programming Books C Java PHP Python Learn more Browse Programming Books
and over one million other books are available for Amazon Kindle. Learn more
Buy New
  • List Price: $49.99
  • Save: $14.65 (29%)
Only 8 left in stock (more on the way).
Ships from and sold by
Gift-wrap available.
Add to Cart
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Professional Microsoft SQL Server Analysis Services 2008 with MDX Paperback – March 16, 2009

ISBN-13: 978-0470247983 ISBN-10: 0470247983 Edition: 1st

Buy New
Price: $35.34
35 New from $7.99 22 Used from $3.76
Amazon Price New from Used from
"Please retry"
"Please retry"
$7.99 $3.76


Frequently Bought Together

Professional Microsoft SQL Server Analysis Services 2008 with MDX + Professional Microsoft SQL Server 2008 Integration Services
Price for both: $67.81

Buy the selected items together


Shop the new
New! Introducing the, a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 1056 pages
  • Publisher: Wrox; 1 edition (March 16, 2009)
  • Language: English
  • ISBN-10: 0470247983
  • ISBN-13: 978-0470247983
  • Product Dimensions: 8.7 x 7.9 x 2.4 inches
  • Shipping Weight: 3.6 pounds (View shipping rates and policies)
  • Average Customer Review: 3.7 out of 5 stars  See all reviews (7 customer reviews)
  • Amazon Best Sellers Rank: #702,534 in Books (See Top 100 in Books)

Editorial Reviews

From the Back Cover

The new features of Analysis Services 2008 make it even easier to use andbuild your databases for efficient and improved performance. This authoritative book, written by key members of the Analysis Services product team at Microsoft, explains how to best use these enhancements for your business needs. The authors provides you with valuable insight on how to use Analysis Services 2008 effectively to build, process, and deploy top-of-the-line business intelligence applications.

You'll explore everything that Analysis Services 2008 has to offer and examinethe important features of this product with the help of step-by-step instructionson building multi-dimensional databases. Within each chapter, you will not only learn how to use the features, but you'll also discover more about the features at a user level and what happens behind the scenes to make things work. You'll get a look at how features really operate, enabling you to understand how to use them to their full potential. Plus, you'll sharpen your ability to debug problems that you might not have been able to otherwise.

What you will learn from this book

  • The basic concepts of using Analysis Services and the common operations you need to design your databases

  • How to create multi-dimensional databases (such as multiple measure groups, business intelligence wizards, key performance indicators, and more)

  • Methods for extending MDX via external functions

  • Ways to administer your Analysis Services programmatically and design and optimize your cube for best performance

  • How data mining along with Microsoft Office 2007 makes it easy to use and effective to perform analysis on data

Who this book is for
This book is for database and data warehouse developers and administrators interested in exploiting the power of business intelligence and leveraging the SQL Server 2008 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; National Center for Data Mining, University of Illinois at Chicago; 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 currently is a Senior Test Lead in the Analysis Services team. Siva's other interests include high - performance computing, distributed systems, and high-speed networking. Siva is married to Shreepriya and has twins, Praveen and Divya. His personal interests include travel, games, and sports (in particular carrom, chess, racquet ball, and board games). You can reach Siva at

Matt Carroll is currently a Senior Development Lead on the SQL Server Integration Services team at Microsoft. Prior to this, he spent 10 years working on the SQL Server Analysis Services team as a developer and then development lead. He's presented on Analysis Services at VSLive and compiled and edited the whitepaper "OLAP Design Best Practices for Analysis Services 2005."

Sethu Meenakshisundaram has more than 20 years of Enterprise System Software Development experience. Sethu spent a good portion of his career at Sybase Inc. in architecture, development, and management building world class OLTP and OLAP Database Systems. Sethu was instrumental in developing and leading highly complex clustered systems of Adaptive Server Enterprise. Early in the '90s, Sethu developed a version of Sybase Adaptive Server running on the Windows platform. Most recently he was an Architect in the SQL Server BI team driving technology and partner strategy. Prior to Microsoft, Sethu managed all of Server development as Senior Director at Sybase including building teams in the U.S., India, and China. He is currently a Vice President in charge of Technology Strategy at SAP Labs, USA.

Rob Zare is a program manager on the SQL Server development team. He's worked on the product since shortly before the first service pack of SQL Server 2000. During that time, he's focused primarily on Analysis Services, though for the next major release of SQL Server he'll be focused on Integration Services. He is the co-author of Fast Track to MDX and regularly speaks at major technical conferences around the world.

Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of "SQL Server 2000 Data Warehousing with Analysis Services" and "Transforming Healthcare through Information [Ed. Joan Ash] (2008)". In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and, you can also review Denny's Space ( Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.7 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

11 of 13 people found the following review helpful By Binh N. Cao on June 30, 2009
Format: Paperback
I am a microsoft professional consultant who makes a living working with Microsoft BI toolsets. I find this book of tremendous value because of the contents and because of who wrote it. The authors are part of the SSAS product group as well as [...] team (the #1 BI application team that takes on the world's largest and greatest database and Business Intelligent design challenges and delivers great designs and success stories)...this is the best of the best at Microsoft. I read the book end-to-end. I can tell you that the MDX, performance tuning, and scenario chapters alone, are worth the price of the book many times over. This book helped me succeed in my job and go further than other consultants. I would highly recommend this book to "professional" consultants. Beginners who want to learn the fundamentals to MSFT BI would benefit greatly from this best-practices microsoft team.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Baya on January 5, 2010
Format: Paperback
Buyers - be aware, you need this book. Analysis Services is a huge product and it's impossible to cover all aspects of it. But this is a 1000 pages well worth your time and money.
If there was one thing that could be improved about this book it would be adding even more, complete examples. On a few occasions the book says "we'll let you (the reader) explore this functionality". With all examples the book could easily have been over 1500 pages long.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Ron Davis on September 4, 2011
Format: Paperback Verified Purchase
This is an excellent book that does a great job of explaining some rather exoteric concepts. The authors may suffer from being too close to the topic to have named the book. By that I mean having MDX in the title may give the impression that the book was focused on writing queries with MDX which it is not. They, the authors, know that SSAS uses MDX internally which I think is why they put MDX in the title.
If you want to get beyond basic querying with MDX it would behoove you to know more about SSAS then the syntax of a Select statement and this book will server that purpose wonderfully.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By Antonio on July 26, 2011
Format: Paperback
On a first glance, it appears to be a great book. However, it turns out that it's a complete waste of time and hardly touching on MDX. Too general and directed those who want a broad idea on how SSAS works. This is the first time I get disappointed with WROX. Don't spend more than £10 on it.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images