O'Reilly logo

Expert Cube Development with SSAS Multidimensional Models by Marco Russo, Alberto Ferrari, Chris Webb

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required