Book Image

Expert Cube Development with SSAS Multidimensional Models

By : Alberto Ferrari, Marco Russon, Chris Webb
Book Image

Expert Cube Development with SSAS Multidimensional Models

By: Alberto Ferrari, Marco Russon, Chris Webb

Overview of this book

Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Chapter 10. Going in Production

When the Analysis Services cube development is completed, its life – from the developer's point of view – is over. Nevertheless, its real life, from the user's point of view, has just begun. During development we probably didn't care too much about what would happen once the cube was in production, but of course there are a whole new set of problems that must be dealt with when a cube has gone live. We are going to address these problems in this chapter.

The focus in this chapter is on the following topics:

  • Making changes to a cube in production: These changes will still need to be made to the cube once it's in production, but we need to be very careful about how we make them in case we accidentally break reports, overwrite properties, or unprocess objects.

  • Managing partitions: Partitioning our cube is good for two reasons: to improve query performance and to reduce the amount of processing we need to do. In production, new data will need to be loaded into...