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.
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 ...