Saturday, October 21, 2017

Changing sql-server database from tabular to multidimensional

From yesterday onwards, I am stuck up with an error while trying to deploy cube.
"You cannot deploy the model because the localhost deployment server is not running in multidimensional mode. "

I started googling to find a solution. And I found it. By default, when we are installing sql server Analysis services use tabular mode. Without reinstalling, if u want to change to multidimensional mode, follow this steps.

Change the deployment mode
  • Go to the path "C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config" and copy the file "msmdsrv.ini" to desktop.
  • Open the file "msmdsrv.ini" and change the value of DeploymentMode to 0.
    0 - Multidimensional
    1 - SharePoint
    2 - Tabular
  • copy the "msmdsrv.ini" back to the location "C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config" . Replace the existing  "msmdsrv.ini" file.
  • Restart the SQL Server Analysis Services (MSSQLSERVER) from Administartive Tools-> Services.
  • Deploy again. Success.


To know more, click the link below to change from multidimensional to tabular mode.

8 comments:

  1. Hat's off to you! Thanks so much. :)

    ReplyDelete
  2. hi, i am unable to start the service again after changing the deployment mode value to 0. when i revert it to 2 it starts again.

    ReplyDelete
    Replies
    1. bro did you find a way to fix this? mine also only works on 2

      Delete
  3. I am not finding deployment mode in the config file

    ReplyDelete
  4. Thank you so much. Greatly appreciated.

    ReplyDelete
  5. Thank you very much!! Your steps helped me.

    ReplyDelete

GEN AI

  Stay Tuned....