Change SSAS Deployment mode from multidimensional to tabular mode without reinstalling Analysis Services | SansSQL

Monday, November 25, 2013

Change SSAS Deployment mode from multidimensional to tabular mode without reinstalling Analysis Services

It so happens that sometimes minds change easily and things needs to be done without reinstalling.
One such case is changing the Deployment mode of SSAS from multidimensional to tabular mode in SQL Server 2012.
To change the deployment mode
  • Backup the multidimensional Analysis services databases on the instance (if any)
  • Detach the multidimensional Analysis services databases from the instance (if any). These databases will not be usable in tabular mode
  • Navigate to the path "<Install Location>:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config" and backup the file "msmdsrv.ini"
  • Open the file "msmdsrv.ini" and change the value of DeploymentMode to 2.
    0 - Multidimensional
    1 - SharePoint
    2 - Tabular
  • Re-Start the SQL Server Analysis services 
SSAS multidimensional mode - Before Change

SSAS tabular mode - After Change

3 comments:

Kev And Charlotte said...

Thank you! most helpful.

Sammy Deprez said...

Any one ever had any consequences because of changing this.
Am not sure this is the issue of my problem. But if I have a Role with RowFilter that uses USERNAME().
USERNAME() never returns the correct user...

from A True Guy said...

I was wondering how to get back to multidimensional mode from tabular mode. Such a wonderful post. Thanks mate...

Post a Comment