question

ismepopola-4101 avatar image
0 Votes"
ismepopola-4101 asked ismepopola-4101 answered

how to change tabular mode to multidimensional model?

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?

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @ismepopola-4101,

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
134467-path.png

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 ).
134438-2.png

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.
134512-3.png

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.






path.png (10.9 KiB)
2.png (36.0 KiB)
3.png (28.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ismepopola-4101 avatar image
0 Votes"
ismepopola-4101 answered

Thank you ,you're so nice!!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.