Search code examples
sql-serverssassql-server-data-tools

SSAS - Cube Deployment Error SQL Server 2014 Enterprise - VS 2015


I've created a adventure works cube for my learning purpose on Azure VM.

  • Multidimensional When I try to deploy Visual studio throws up this error.

enter image description here


Solution

  • To deploy a cube on SQL Server 2014, you must create it in Visual Studio 2013.

    Visual Studio 2015 creates cubes for SQL Server 2016, which is why the cube has a compatibility level that SQL Server 2014 doesn't know how to handle.