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 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-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 
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.
4 people are following this question.
File for a cloned Vertipaq data object conflicts with a master data object file
dimension security on a combination of dimensions
integration services ne figure pas dans la liste des fonctionnalités partagées de sql server
Getting error message as "Unable to find any Microsoft OLE DB providers on the machine."
How to schedule SQL profiler to auto start/stop to capture SSAS synchronization?