Going in Production - Expert Cube Development with SSAS Multidimensional Models - page 313

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.

• How processing can be managed using Integration Services. The Process

Analysis Services Task is the easiest way of doing this, but other Control
Flow tasks such as the Execute Analysis Services DDL Task can also be used.
It's also possible to push data directly into partitions and dimensions in the
Integration Services Data Flow.

• Methods for copying databases between different instances of Analysis

Services. The Synchronize command is the easiest way of doing this, but
attaching and detaching databases is another option.