Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?

Hi @ismepopola , Welcome to Microsoft Q&A! You don't need to uninstall SSAS, please refer to below steps: 1.Access to C:\Program Files\Microsoft SQL Server\MSAS14.SQLSERVER2017\OLAP\Config and then find msmdsrv 2.Cope the file to a temp folder, open with notepad. In the below screenshot, the Deployment mode is set to 2 ( tabular mode ), you should change it to 0 ( multidimensional model ). 3.Copy and replace the msmdsrv.ini file back to the OLAP\Config directory. 4.Go to services.msc and restart the Analysis Services instance. 5.Connect to the server in SQL Server Management Studio, and then you could find that the model has been changed. For more information, please refer to this blog . Best regards, Carrin If the answer is helpful, please click " Accept Answer " and upvote it. Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

how to change tabular mode to multidimensional model？

Accepted answer

CarrinWu-MSFT 6,871 Reputation points

2021-09-23T03:03:15.59+00:00

Hi @ismepopola ,

Welcome to Microsoft Q&A!

You don't need to uninstall SSAS, please refer to below steps:

1.Access to C:\Program Files\Microsoft SQL Server\MSAS14.SQLSERVER2017\OLAP\Config and then find msmdsrv

2.Cope the file to a temp folder, open with notepad. In the below screenshot, the Deployment mode is set to 2 ( tabular mode ), you should change it to 0 ( multidimensional model ).

3.Copy and replace the msmdsrv.ini file back to the OLAP\Config directory.

4.Go to services.msc and restart the Analysis Services instance.

5.Connect to the server in SQL Server Management Studio, and then you could find that the model has been changed.

For more information, please refer to this blog.

Best regards,
Carrin

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.

8 people found this answer helpful.
Stitt, Dana 1 Reputation point

2022-11-16T14:25:48.637+00:00

This doesn't work in sql 2019. Do you know the way to switch it in 2019.?

Braulio Solano Vega 1 Reputation point

2022-11-30T20:06:10.333+00:00

It worked for me with SQL 2019, Thanks.

Martin Belak 0 Reputation points

2023-01-27T11:47:20.71+00:00

004_multi_dimensional_model.jpg

Hello. Nice!

Following the steps, I was able to successfully change the tabular model of the Microsoft Analysis Services to multi dimensional.

Thanks.

Nemanja Mijajlović 0 Reputation points

2024-03-18T11:48:18.1433333+00:00

Very simple and straightforward! Thank you a lot
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

how to change tabular mode to multidimensional model？

2 additional answers

Your answer