SQL Server 2012 (“Denali”): Installing SSAS Multidimensional vs Tabular Mode

As I play with the recently released CTP3 of SQL Server 2012, code name of Denali, I wanted to point something out about installing SSAS, since there is now two “modes” you can choose from due to the the new BI Semantic Model (I covered these new features here).

During installation, when you are on the “Analysis Services Configuration” screen, you are given a choice of which server mode to use: “Multidimensional and Data Mining Mode” or “Tabular Mode”.  You can’t install both on one instance.  This means if you want to use both, you will need to install two instances of SSAS.  To do that, you need to run the setup again after the first instance setup (you cannot install two instances in the same setup).  I would suggest you call the instances servername\multi and servername\tabular.

How do you tell if SSAS was installed with the tabular model or the multidimensional model?  There is no explicit property that you can view for this.  Instead, in SSMS you will see that the server running in VertiPaq mode supporting the Tabular project types has a blue ‘table icon’ and the SSAS Multidimensional mode has the traditional SSAS/DB icon (NOTE: If you have installed PowerPivot for SharePoint, you will see another icon: ).  In addition you can expand the tree view where the ‘Tables’ node will give away the fact that it’s a tabular model:

The first time I installed SSAS I choose the default “Multidimensional and Data Mining Mode” and did not use an instance name.  When I installed SSAS the second time I choose “Tabular Mode” and called the instance localhost\tabular.  When I created an Analysis Services Tabular Project, I received the error:

This is understandable as “localhost” is my default install of SSAS and uses the Multidimensional mode.  To fix this, I went to the properties of the Model.bim file and updated the “Workspace Server” to point to the SSAS instance that has the Tabular mode:

Marco Russo has discovered even more ways to tell which model was installed: Detect Tabular or Multidimensional Version in #ssas #denali #ctp3

Understanding Analysis Services Deployment Modes

About James Serra

James currently works for Microsoft specializing in big data and data warehousing using the Analytics Platform System (APS), a Massively Parallel Processing (MPP) architecture. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence/MDM architect and developer, specializing in the Microsoft BI stack. He is a SQL Server MVP with over 25 years of IT experience.
This entry was posted in BISM, SQL Server, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular. Bookmark the permalink.

One Response to SQL Server 2012 (“Denali”): Installing SSAS Multidimensional vs Tabular Mode

  1. Pingback: SQL Server "Denali": CTP3 now available! | James Serra's Blog

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>