Search code examples
sql-servermultidimensional-arrayssassql-server-2014tabular

Changing SQL Server DB from tabular to multidimensional

I have following problem: When I try to deploy my SSAS project (with cube, dimensions and all that jazz) to sql-server, it throws error saying that

You cannot deploy the model because the DB deployment server is not running in multidimensional mode.

I'm new to this, so it might be a dumb question, but how do I change database mode from tabular to multidimensional?

Solution

  • Tabular and Multi Dimensional are completely different thing. When you install SQL Server, you have to choose which one you are going to install.

    So, if you create a Tabular model, you only can deploy it to Tabular installation of SSAS and the same for Multi Dimensional

    you can not convert those model to each other.