Search code examples
ssasazure-analysis-services

How to create SSAS server in Multidimensional mode?


How to create an SSAS server in Multidimensional mode? I have created an SSAS server using Azure. But it was created in tabular mode. I can't change the mode. I need a SSAS server in multidimensional mode. Please help me out.


Solution

  • You provisioned Azure Analysis Services (the one where you connect via asazure://...) but Multidimensional isn't currently supported. Please vote for it.

    For other peoples' use in the future... if you created a VM and accidentally installed SSAS In Tabular mode then you can edit msmdsrv.ini and set DeploymentMode to 0 and restart the SSAS Service (kind of the opposite of what Cathy Dumas did here). That will switch the instance to Multidimensional mode.