We started using SSAS recently and we maintain we one project to deploy to both DEV and PROD instances by changing the deployment properties. However, this gets messy when we introduce new fact tables in to DEV data warehouse (that are not promoted to Production data warehouse). While we work on adding new measure groups and calculations (based on new fact tables in DEV) we are unable to make any changes to production cube (such as changes to calculations, formatting etc) requested by business users. Sorry for long question but is there is a best practice to manage projects and migrations? Thanks.

http://technet.microsoft.com/en-us/sqlserver/bb671430.aspx

http://technet.microsoft.com/en-us/library/hh393546.aspx