Search code examples
sql-servervisual-studiossastabularcube

The server content appears to be out of date. Would you like to build and deploy the project first?


i created cube in analysis services in VS 2017
my problem is i cant process .cube file to sql server
this is error message i get

The server content appears to be out of date. Would you like to build and deploy the project first?


i have analysis services server opened in background
in services both analysis services server and sql server browser are active
i would appreciate any kind of help


Solution

  • This means that the definition of the cube and/or database on your database server are different from what is in your project in Visual Studio. Meaning somebody made changes to one, but not the other.

    You need to bring them into sync before you can process the cube from your Visual Studio project.

    If you want to overwrite what's on the server with what's in the project, just build and deploy the project.

    If you want to overwrite your project with what's on the server, you'll need to generate a new project by importing from your database, and use it to replace your existing one.