– Only applies to CTP3 Denali SQL Server
If you look into the Anaysis service object in Management Studio , We can identify the server mode by checking the server icons . The second one in the picture shows the tabular mode. This selection is making while on setup process . The below example shows the multidimensional mode
For changing servermode
A server can only be deployed in one mode, and from a supportability standpoint, that mode is fixed at the time you install the software. However, if you recently installed the server and have not deployed any databases, you can safely switch the server mode between Tabular and Multidimensional. To do this, you change the DeploymentMode property in msmdsrv.ini and then restart the server. Valid values are 0 for Multidimensional and 2 for Tabular. This is possible in the other way also. The path for msmdsrv.ini is C:\Program Files\Microsoft SQL Server\MSSQL.n\OLAP\Config
Once you change it , you may need to restart analysis service. After that you can see the icon changed.