Analysis Services 2005 was a significant leap from Analysis Services 2000, from the concept of building your cubes in Business Intelligence Development Studio (BIDS) to the concept of the Unified Dimensional Model (UDM) with attribute and user hierarchies. The first edition of this book, Professional SQL Server Analysis Services 2005 with MDX, was aimed at novice to advanced users and was very well received by its readers. Analysis Services 2005 was a large and complex product that needed a lot of fine-tuning to get the best performance.

Analysis Services 2008 added enhancements to the developer toolset and the server itself that made it easier to build your databases right with efficient performance. The second edition of this book was written to provide insight into those enhancements and to help you understand how to utilize them effectively for your business needs. Because Analysis Services 2008 was an incremental release, the second edition of the book had a similar structure to the first, but enhancements were made to each chapter of the book. The second edition was still targeted at novice to advanced users.

Between Analysis Services 2008 and the current major version, Analysis Services 2012, Microsoft released SQL Server 2008 R2, which introduced PowerPivot, Microsoft's entry into the self-service business intelligence arena. PowerPivot's goal was to bring the benefits of business intelligence (BI) to a larger audience with a simpler, easier to understand data ...

Get Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.