Expert Cube Development with SSAS Multidimensional Models

Summary

In this chapter, we have discussed several topics:

• How to deploy changes to a database already in production, using Visual Studio configurations or the Deployment Wizard.
• Automating partition management using Integration Services and AMO code to create, merge, and delete partitions.
• Processing strategies. Although we always want to minimize the amount of time spent processing, there is no one processing strategy that is appropriate for all projects. In most cases, a Process Update will handle any updates to dimensions; this can then be followed by a Process Default on our partitions, which will rebuild any aggregations that have been invalidated by dimension processing on existing partitions, and fully process any newly created partitions. ...