SQL Server Analysis Services can be installed in one of three modes.
- Tabular
- Multidimensional
- SharePoint
How to check the current analysis server mode?
We can check the current mode by checking the properties of the analysis server.
Connect to the Analysis server and right-click to go to the properties option.
Check the Server mode option. Currently, it's showing in tabular mode.
Alternatively, the DeploymentMode property in the msmdsrv.ini file also has details.
The default path of the msmdsrv.ini file is %Program FilesMicrosoft SQL ServerMSAS15.MSSQLSERVEROLAPConfig
% can be a location where SQL Server and Analysis services are installed.
Right-click and edit msmdsrv xml configuration setting file .
The value of this property identifies the server mode.
Valid values are,
- Multidimensional =0
- SharePoint =1
- Tabular =2
How to change the current tabular mode to multidimensional or SharePoint?
Edit msmdsrv XML (shown above) and change value according to the requirement.
I require to change it to Multidimensional, and it needs to update the DeploymentMode option msmdsrv.xml file to 0.
Save the updated file and restart the Analysis Services.
Now again, check the Analysis Server properties to confirm the updated mode.
The multidimensional mode is now ready to use.
In the same way, we can change to Sharepoint mode by updating the value to 1.
As shown below, the analysis server is in SharePoint mode.
