To get the free app, enter your mobile phone number.
Microsoft SQL Server 2008 Analysis Services Unleashed Paperback – December 24, 2008
|New from||Used from|
ITPro.TV Video Training
Take advantage of IT courses online anywhere, anytime with ITPro.TV. Learn more.
Frequently Bought Together
Customers Who Bought This Item Also Bought
From the Back Cover
- 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
About the Author
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.
Top Customer Reviews
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.
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.
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 ›
Something that is rarely appreciated is just how open Microsoft has always been with respect to this product in allowing such detailed information on its inner workings to be made publicly available. The chapters on internals are the most valuable compared to other information sources that are out there.
It is true as another reviewer complained that there exist an unnecessary number of grammatical, syntax and spelling errors (the only reason I don't give 5 stars), but they are and I hate to say it, minor irritants compared to the valuable information presented. The other negative reviews I just don't grock at all. If I have any complaint it is that many of the internals details are presented so matter-of-factly that they can slide right by you without your realizing their significance or implications. They also could have included more on how the workings that are revealed relate to the many server parameters you can adjust and the many performance monitor counters you can utilize in SQL Server Profiler and perfmon to gain deep insight into what is going on underneath.
If you aren't already conversant with Profiler, get a good book on it too, like Mastering SQL Server Profiler by Brad McGehee - it's focused on SQL Server counters but it all applies to AS also.Read more ›
Most Recent Customer Reviews
Helpful insight into Analysis Services. Inna Gorbach often is able to elaborate in a neat and concise manner and this book is no exceptionPublished on May 17, 2014 by Paul Forster
This book is all detail and no big picture. I didn't even find it useful as a reference. Save your money.Published on May 12, 2014 by Donald Schaeffer
This was a great resource for my project. I looking forward to review other books on your list in the near future.Published on March 3, 2014 by cfrench
This may be an excellent choice for expert SSAS users - see the five-star reviews - but I do not recommend it for the intermediate audience. Read morePublished on March 11, 2013 by Dimitri Shvorob
This book contains detailed insights into the internals of Analysis Services and is a must own for any Analysis Services professional.Published on February 3, 2013 by Wayne Robertson
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. Read morePublished on March 25, 2011 by Eric J. Lynch
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. Read morePublished on February 16, 2011 by Boyan Penev
Through the first 3 chapters I felt like the book may have some promise. True, the brief overviews didn't really pertain to any major aspects of Analysis Services, but it was... Read morePublished on July 23, 2009 by JC
I found this book to be extremely informative. I have read many other books on SSAS and I found that this book can tell you a lot about how SSAS really works. Read morePublished on July 4, 2009 by Abhishek Srivastava