CODEWITHSUNDEEP
sql-serverssasssas-tabular
user6479259
user6479259

Reputation: 47

SSAS is deploying to a new cube

When I update my SSAS cube and deploy it, all changes are deployed to a new cube on Analysis services database

enter image description here

deploying process is supposed to replace any pre-existing database with the contents of the project deployed. So why it is not deploying in the right cube and instead it is creating a new one with the same name_username_reference ? how can I avoid this ?

Upvotes: 0

Views: 644

Answers (1)

userfl89
userfl89

Reputation: 4790

That's your workspace database, which includes your username followed by a GUID in the database name. To ensure that you're deploying the correct Tabular model, from SSDT right-click on your SSAS project, in the Deployment pane (under Configuration Properties) verify that the correct database name has been entered in the Database field in the Deployment Server section.

Upvotes: 4

Related Questions