Analysis Services Server Modes in SQL Server 2012

added by kalyanms1
9/5/2012 6:00:51 PM

-1 Kicks, 54 Views

SQL Server 2005 and 2008 supports only one mode that is multidimensional mode, Where as SQL Server 2008 R2 supports additional mode PowerPivot for SharePoint. In SQL Server 2012 you have an option to deploy an analysis services instance in tabular mode. This post discusses the Analysis server modes and enhancements in SQL Server 2012.