When developing a SQL Server Analysis Services project, one normally deploys the project to a dev or test server before deploying to an acceptance or production environment to test the solution. After testing is completed, and once the solution has been deployed to the acceptance/production server, an administrator may change the role-based security.
When deploying an update of the solution, you have to decide if you want to retain those changes or if you want to overwrite them.
SSAS includes a tool called the Deployment Wizard which will allow you to do exactly what you want. When using the Wizard, one has to determine how existing security roles, permissions and role members are treated during deployment.
Default the Wizard suggests to overwrite the changes made by the administrator.
However if you select “Retain roles and retain members.”, you don’t overwrite the changes made by the administrator.
