Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query languag MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as the foundation for the Microsoft Business Intelligence strategy.
Microsoft SQL Server 2005 Analysis Services gives the reader insight into the way Analysis Services functions. It not only explains ways to design and create multidimensional objects, databases, dimensions, and cubes, but also provides invaluable information about the reasons behind design decisions made by the development team.
Here's what you will find inside:
Understand the key concepts of multidimensional modeling
Explore the multidimensional object model and its definition language
Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
Understand the mechanisms of integrating multidimensional and relational databases
Learn how to build client applications to access data in Analysis Services
Examine server architecture, including main data structures, data processing, and query resolution algorithms
Gain a deep understanding of the internal and external protocols for data transfer, including the XML/A protocol
Explore how Analysis Services manages memory
Explore the security model, including role-based security, code-access security, and data security
Discover how to monitor and manage Analysis Services
All the code for the sample database used in the book can be found at www.informit.com/title/0672327821.
buy only if you really care about internals of analysis servicesFebruary 14, 2010 Sam S(Needham MA) complete waste of time and money. users of analysis services should have no business learning how msas works under the hood. if you want to learn mdx and cube design principles read something else.
This book is best designed for reference or review (not learning)August 15, 2009 Rick A. Morelan 1 out of 1 found this review helpful
OK here is an example of smart, comprehensive, hard working people writing a book that unfortunately takes far too much will power to try to learn from. It's the kind of book you can understand only if you already know most of it before you read it. So it's really reference review material. As an author I know they worked hard and put much of their lives into it. It makes a good reference book I will give it three stars. Great reference, not a good learning tool. Sorry.
Very technical but drastically in need of an editor(s)March 12, 2009 Dr. Jazz(NYC) 1 out of 1 found this review helpful
I read a good part of this book (before I left it on a bus!) and found it both invaluable and infuriating.
It contains information not found in any other SSAS 2005 book I have come across (I own and have read about 5 others), but it is sorely in need of a traditional book editor to make the language (English) readable and a technical editor to bring the explanations down to a level that can be understood by mere mortals.
Invaluable, because it is the only book that covers certain information about the SSAS engine internals, but it could have been so much more useful to we SSAS practitioners if the writing was better.
Good Reference, but Don't Expect Tips and Tricks or even Ideas on Problem SolvingJuly 14, 2008 Che J. Hsu(San Francisco) 1 out of 1 found this review helpful
I bought this book because I was facing a few specific problems while implementing Analysis Services. This book did not help much there. As I was reading, I found that this book does have great content on the design of MS-AS2005. It's a great reference book to have handy because it consolidates information in one book and often describes the motivations for certain designs. Likewise, the book never discussed the significant missing feature in the product, nor workarounds to handle some of the very common requirements. That, while not surprising given the authors are from Microsoft design team, is not helpful.
Ultimately I don't regret buying this book, but don't expect it to solve many of your challenging problems. The materials in this book should have been included in the original product documentations!
Get this book if you want to master SSASJune 15, 2008 Tech Guy(USA) 2 out of 2 found this review helpful
I came from the world of Hyperion Essbase and decided to switch to Microsoft SQL Server Analysis services. The SQL server books online seemed to be lacking in some details (or examples) and other SSAS printed books seem to be more of the beginner level books or step by step tutorial books. They are good to start with but not deep enough. If you are just starting in the BI and OLAP world, get those books first.
This book is not a general BI book and is more specific to SSAS details. Because of my prior understanding of of data warehousing and OLAP, I was able to build SSAS cubes in no time but there were some lingering questions on how do I do this in SSAS (compared to doing it in Essbase) and other low level details. This is the only SSAS book that I found so far that goes into enough details of SSAS that no other book goes into.
If you are just starting with Microsoft BI and need to learn the concepts of data warehousing (star and snowflake schema), OLAP, ETL and SSIS, get one of the other books first. Then do the SSAS books online tutorials. Once you are ready to dig deeper into SSAS and build enterprise class analysis services cubes, this book would be a great help.
Here is a quote from Nigel Pendse of The OLAP Report in the foreword of this book:
"This book is not intended to teach new users how to use Analysis Services 2005; it is for technically competent implementers who want to make the most of Analysis Services by understanding how it really works..."
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
