In SQL Server 2012, There are two modes of installing Analysis Services – “Multidimensional and Data Mining Mode” and “Tabular Mode”. During the install you can install only one of the above, not both. If you’d like to have both, you will need to create a new instance of Analysis Services by launching the SQL Server 2012 setup again and choose the Tabular Mode in the “Analysis Services Configuration” page.







With SQL Server 2012, there are two types of Analysis Services projects in Business Intelligence Development Studio (BIDS). You can create and edit the multidimensional projects that you all know and love. You can also use BIDS to create tabular projects.

Check out these additional resources on Tabular Models:

http://blogs.msdn.com/b/analysisservices/archive/2011/07/13/welcome-to-tabular-projects.aspx