A couple of years back I reviewed a new book on the market related to MDX and Analysis Services, Book Review: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook, and the book has now been updated to 2012. The book was written by Microsoft SQL Server MVP Tomislav Piasevoli and Sherry Li. The cookbook style of book is an outstanding reference book. The book is full of solutions that tell you “how to do it”, “how it works”, and wait, “there’s more” (great value add and insights).
The book has been updated for the 2012 edition of SSAS and the examples have also been updated against the 2012 version of Adventure Works database. The other difference from the 2008 R2 release of the book is that some of content has been broken up into a a couple of new chapters.
- Chapter 1: Elementary MDX Techniques
- Chapter 2: Working with Sets
- Chapter 3: Working with Time
- Chapter 4: Concise Reporting
- Chapter 5: Navigation
- Chapter 6: Business Analytics
- Chapter 7: When MDX is Not Enough
- Chapter 8: Advanced MDX Topics
- Chapter 9: On the Edge
Book link – MDX with SSAS 2012 Cookbook. Amazon reviews link – Amazon Customer Reviews.
I would definitely rate this a must have for anyone doing multidimensional SSAS development and give it 5 out of 5 stars – .