Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

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

  • List Price: $59.99
  • Save: $17.51 (29%)
Only 6 left in stock (more on the way).
Ships from and sold by Amazon.com. Gift-wrap available.
Microsoft SQL Server 2008... has been added to your Cart
+ $3.99 shipping
Condition: Used: Good
Comment: Former Library book. Shows some signs of wear, and may have some markings on the inside. 100% Money Back Guarantee. Shipped to over one million happy customers.
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 all 2 images

Microsoft SQL Server 2008 Analysis Services Unleashed Paperback – December 24, 2008

3.4 out of 5 stars 16 customer reviews

See all 2 formats and editions Hide other formats and editions
New from Used from
"Please retry"
"Please retry"
$19.88 $10.93

Top 20 lists in Books
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
$42.48 FREE Shipping. Only 6 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Microsoft SQL Server 2008 Analysis Services Unleashed
  • +
  • Microsoft SQL Server 2008 Integration Services Unleashed
  • +
  • Microsoft SQL Server 2008 Reporting Services Unleashed
Total price: $115.22
Buy the selected items together

Editorial Reviews

From the Back Cover

As the foundation of the Microsoft Business Intelligence Strategy, Microsoft SQL Server 2008 Analysis Services provides users with faster access to data and even more tools for managing and analyzing data across multidimensional objects (databases, dimensions, cubes). "Microsoft SQL Server 2008 Analysis Services Unleashed" is the ultimate guide for anyone who is planning to use the latest version of Analysis Services. It gives readers insight into the way Analysis Services functions, and explains practical methods for designing and creating multidimensional objects. It also provides valuable insight into the reasons behind the design decisions taken by the product development team. The authors have been involved with Analysis Services from its earliest days. They have documented in detail the internal features of Analysis Services 2008, explaining server architecture, main data structures, data processing, and query resolution algorithms.
  • Discover the new functionality introduced in Analysis Services 2008 including MDX enhancements and new DMV (dynamic memory views)
  • Work with the Business Intelligence Development Studio, the new Dimension Editor, and Aggregation Designer interfaces
  • Enjoy complete coverage of new Shared Scalable Databases scale-out infrastructure
  • Learn the key concepts of multidimensional modeling
  • Explore the multidimensional object model and its definition language
  • Integrate multidimensional and relational databases
  • Build client applications to access data in Analysis Services
  • Unravel the inner workings of the server architecture, including main data structures, data processing, and query resolution algorithms
  • Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
  • Gain a deeper understanding of the internal and external protocols for data transfer, including the XML/A protocol
  • Discover how Analysis Services manages memory
  • Explore the security model, including role-based security, code-access security, and data security
Category: Microsoft SQL Server Covers: Microsoft SQL Server 2008 Analysis Services User Level: Intermediate-Advanced $59.99 USA / $65.99 CAN / 38.99 Net UK

About the Author

Irina Gorbach is a senior development lead at Microsoft. She joined the Analysis Services team soon after its creation over 11 years ago. During her work at Microsoft, Irina has designed and developed many features of the Analysis Services product, and was responsible for client subsystem: OLEDB and ADOMD.Net. Irina was in the original group of architects that designed XML for Analysis specification; she worked on the architecture and design of calculation algorithms and currently is working on scalability of Analysis Services.


Alexander Berger was one of the first developers to work on OLAP systems at Panorama, prior to their purchase by Microsoft. After the acquisition, Alexander led the development of Microsoft OLAP Server through all of its major releases prior to SSAS 2008. Currently, Alexander leads the Business Intelligence department for Microsoft adCenter. He is one of the architects of OLEDB for the OLAP standard and MDX language, and holds more than 30 patents in the area of multidimensional databases.


Edward Melomed is one of the original members of the Microsoft SQL Server Analysis Services team. He arrived in Redmond as part of Microsoft’s acquisition of Panorama Software Systems, Inc., which led to the technology that gave rise to Analysis Services 2008. He works as a program manager at Microsoft and plays a major role in the infrastructure design for the Analysis Services engine.


Looking for the Audiobook Edition?
Tell us that you'd like this title to be produced as an audiobook, and we'll alert our colleagues at Audible.com. If you are the author or rights holder, let Audible help you produce the audiobook: Learn more at ACX.com.

Product Details

  • Paperback: 888 pages
  • Publisher: Sams Publishing; 1 edition (December 24, 2008)
  • Language: English
  • ISBN-10: 0672330016
  • ISBN-13: 978-0672330018
  • Product Dimensions: 7 x 1.8 x 9 inches
  • Shipping Weight: 2.8 pounds (View shipping rates and policies)
  • Average Customer Review: 3.4 out of 5 stars  See all reviews (16 customer reviews)
  • Amazon Best Sellers Rank: #1,059,689 in Books (See Top 100 in Books)

Important Information

Example Ingredients

Example Directions

More About the Author

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

Customer Reviews

Top Customer Reviews

Format: Paperback
First, this book is not a tutorial. If you don't know SSAS and want to learn it, look elsewhere first and return to this book later.

What this book provides is an in-depth view of how Analysis Services really works. For those of us who spend most of our time working with Analysis Services, this book is invaluable for understanding how the engine behaves and why. You'll find details on processing, aggregations, attribute relationships, and virtually every other aspect of SSAS. The level of detail is exactly what you would expect from members of the SSAS team at Microsoft, which is to say it is very detailed and technical in nature.

There are five chapters on MDX that explain the subtleties of the various functions and how they perform. There are also chapters that delve into performance tuning, security, and administrative tasks. I highly recommend this book to anyone already familiar with SSAS because it contains valuable information not found anywhere else.
Comment 13 of 13 people 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
Format: Paperback Verified Purchase
I have thousands of hours of experience with SSAS 2000 and 2005. I think that SSAS is one of the best (if unappreciated) Microsoft products.

I bought this book for one reason - it was the first one available. If you need one now, then get it. But be warned that it's not particularly good.

The key problem is that the authors are fascinated with XML. They use raw XML to explain a wide variety of concepts and tasks. For the authors and publishers, it has the benefit of wasting a lot of space. This fattens the book and makes it look like you are getting more for your money.

Unfortunately for the readers, the book is difficult to read and completely misses the point of the SSAS interface. XML is the underlying metadata structure of SSAS. That is the last place you should look to understand cube and dimensional structure, or for modifying how the cube works.

For a professional programmer (me), time is money and productivity is everything. First you should should use the graphical and tabular representation of metadata to manipulate the cubes and dimension. THEN, you write MDX functions when necessary. If all else fails, mess with the XML.

If you can wait a few weeks, there are two new books coming out for AS 2008. I believe either would a much better alternative to this book.

Don't waste your money buying this book like I did.


2 Comments 32 of 38 people 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
By JNL on February 9, 2009
Format: Paperback
If this is the best SSAS book for the hardcore technologist, then I shudder to think what the worst one is.

I bought this book having no knowledge of the SSAS product or MDX. However my preference is for a theory-heavy book rather than a step-by-step introductory tutorial, so I would rather go straight for the jugular with the expert level book. To their credit the authors being deeply involved in the development of SSAS seem to know the product quite well, but their ability to explain concepts effectively and give you the big picture, enabling you to best construct an OLAP system with their product, is a bit lacking.

First, I'm puzzled how a book can go to mass production without someone at least running the text through the grammar checker--there are numerous grammatical errors throughout this book. The index also doesn't seem very accurate. I also found myself questioning the correctness of a couple code samples. These are but the first signs that the book was hastily written & published in an effort to be the first book to market on the 2008 version.

My second problem is with the ability of the authors to explain concepts of a technology that is foreign to people coming from the RDBMS mindset. MDX is an odd language, but many of their explanations & code samples often make the language even more confusing than is probably necessary. Let's take an example: in the cube-based mdx script chapter, they introduce the concept of static vs. named sets. They essentially explain it as such: "dynamic named sets are different than static named sets. Without explaining what a dynamic named set is, we'll just give you a code sample showing you the difference and hope you figure it out.
Read more ›
Comment 10 of 11 people 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
Format: Paperback
This book will not teach you what you need to do to make SSAS work for you. It will make you a PhD in what SSAS does under the hood. The author clearly hasn't used this tool in the real world, even though he is clearly smart enough to have built it. I mean, who really cares about the bit structure of how SSAS stores strings? He also spends a LOT of space showing you the DDL of the data structures you build in SSAS in XML format. Seriously? Wish I hadn't bought this book. It's totally worthless for those of us who have jobs and need to get some real work done.

To coin an analogy, if you were looking for a book on auto racing, this book won't teach you the first thing about winning races. But it'll teach you everything you ever wanted to know about the chemical make up of the metals that were used to cast your engine block. Hope this helps.
1 Comment 3 of 3 people 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
Format: Paperback
If you think that you know SSAS 2008 and you haven't read this book, you should buy and read it. It is the best book on Analysis Services internals on the market.

All negative reviews here are either about it being too complicated or not well written. While to some extent this is correct, I think that the positive sides of this book completely outweigh the negative ones. It is important to understand who is the target audience. If you are learning SSAS from scratch or even if you are on an intermediate level there are other books which will suit you better. However, if you are on an advanced/expert level and want to know more about exactly how SSAS works you will not find any other book which speaks about SSAS in such detail.

Considering that the authors actually _make_ SSAS the material is 100% guaranteed to be accurate and complete.

A must buy for everyone who wants to understand SSAS in full.
Comment 2 of 2 people 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 Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Microsoft SQL Server 2008 Analysis Services Unleashed
This item: Microsoft SQL Server 2008 Analysis Services Unleashed
Price: $42.48
Ships from and sold by Amazon.com