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

Managing processing

During development, we can process cubes or dimensions whenever we want; in a production environment, processing needs more thought though. On a very simple project, we might be able to get away with doing a Full Process on our entire Analysis Services database if it only takes a few minutes to complete. However, we usually have large data volumes to manage and a limited amount of time to perform any processing, so a Full Process simply isn't feasible - we need to think carefully about how we can only process the data that needs to be processed, and do that processing in the most efficient way possible.

Analysis Services processing can be broken down into two different tasks:

  • Dimension Processing: This involves loading data into ...

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