Chapter 9. Processing Optimization

Chapter Objectives Estimated time: 2 hours
In this chapter, you’ll learn what happens when you process a database and you’ll learn how to

  • Avoid problems with cubes stored using HOLAP or ROLAP storage.

  • Incrementally update a dimension or a cube.

  • Avoid problems when incrementally updating a cube.

  • Use partitions to manage large cubes.

  • Use Data Transformation Services (DTS) to automate processing a database.

Conceptually, the Analysis server is a black box, mysteriously converting the values in a data warehouse into a miraculous object called a cube. And for the most part, you can simply ignore what goes on inside that black box and let the Analysis server work its magic. Knowledge is, however, power, and that adage ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial