CHAPTER 9Analysis Services and PowerPivot

In SQL Server 2005 and SQL Server 2008, there is only one mode of SQL Server Analysis Services (SSAS) available. Then in SQL Server 2008 R2, VertiPaq mode debuts as the engine for PowerPivot for SharePoint. These two server modes persist in SQL Server 2012 with some enhancements, and now you also have the option to deploy an Analysis Services instance in tabular mode. In addition, Microsoft SQL Server 2012 PowerPivot for Excel has several new features that extend the types of analysis it can support.

Analysis Services

Before you deploy an Analysis Services instance, you must decide what type of functionality you want to support and install the appropriate server mode. In this section, we compare the three ...

Get Introducing Microsoft® SQL Server® 2012 now with O’Reilly online learning.

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