Chapter 12. Managing Partitions and Database Processing

After completing this chapter, you will be able to:

  • Use partitions to manage large cubes.

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

  • Compare full and incremental updates of a dimension.

  • Avoid problems when incrementally updating a cube.

  • Configure proactive caching.

  • Use performance tools to monitor Analysis Services activity.

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 certainly holds true in the domain of Microsoft ...

Get Microsoft® SQL Server™ 2005 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.