Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Prevent wiping out of SSAS partitions

There have been a few times when I have created SSAS partitions outside of BIDS using script code in an SSiS package, then later made a change in BIDS and deployed the cube, wiping out those partitions (since they did not exist in the BIDS project).

To prevent partitions getting wiped out if you do a deploy from BIDS and have created partitions outside of your project, you should use the deployment wizard: Click Start, point to All Programs, point to Microsoft SQL Server, point to Analysis Services, and then click Deployment Wizard.

If you wanted to update your project so that it reflects those partitions created outside of the project, you can “reverse engineer” a SSAS database and build the Visual Studio analysis services project from a deployed SSAS database.  Just go into Visual Studio, and from the menu choose File -> New -> Project… -> “Import Analysis Services 2008 Database” (in 2012 it is “Import from Server (Multidimensional and Data Mining)”).  Then enter the name and location to save the new project, and that is all that is too it.

Note that if you have an sql server agent job that runs xmla script to process the cube, and this job is run after the deployment is complete in BIDS, then you don’t want the cube to automatically process when you do a deployment (which is the default).  To fix that: right-click on the project node in BIDS and click ‘Properties’.  Then under ‘Configuration Properties’ click ‘Deployment’ and set the ‘Processing Option’ to ‘Do Not Process’.

More info:

Using the SQL Server Analysis Services (SSAS) Deployment Wizard

The Deployment Wizard, and when “Retain Partitions” doesn’t retain partitions

SSAS: BIDS Deployment vs. Deployment Wizard


Leave a comment on the original post [, opens in a new window]

Loading comments...