Change Mode Of SSAS

Below are the details how we can change this mode, please note take a backup of existing CUBES before changing this option.

DeploymentModes :

DeploymentMode=2 for Tabular Mode

DeploymentMode=0 for Multidimensional Mode

DeploymentMode=1 is for PowerPivot for SharePoint instances.

Steps:

1. Backup any multidimensional databases on the server and either detach them or delete them.  Once mode is changed this may not work.
2. Copy the msmdsrv.ini file to safe location this can be found here - C:\Program Files\Microsoft SQL Server\MSAS15.MSSQLSERVER\OLAP\Config.
3. Open the config file in Notepad. Change the DeploymentMode property as required - 0 (multidimensional) to 2 (tabular) Save and close the file.
4. Copy the msmdsrv.ini file back to the OLAP\Config directory.
5. Restart the SQL Server Analysis Services instance.