79285107

Date: 2024-12-16 15:05:37
Score: 1
Natty:
Report link

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

2.Copy 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.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Hasan Rameh