Share via

how to change tabular mode to multidimensional model？

ismepopola 76 Reputation points
2021-09-23T02:32:42.227+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,300 questions
0 comments
Accepted answer
  1. CarrinWu-MSFT 6,876 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
    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.

    8 people found this answer helpful.

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ismepopola 76 Reputation points
    2021-09-23T05:26:22.547+00:00

    Thank you ,you're so nice!!

    1 person found this answer helpful.
    0 comments
  2. Divyang Vinubhai Hirpara 0 Reputation points
    2023-04-14T04:31:20.7166667+00:00

    Thank you for your help!

    0 comments
  3. Paul Garnes 0 Reputation points
    2024-12-01T01:55:58.1766667+00:00

    Changing the DeploymentMode Property is not supported according to this article: https://zcusa.951200.xyz/en-us/analysis-services/instances/determine-the-server-mode-of-an-analysis-services-instance

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.