Managing OLAP Processing

The easiest way to make sure that an OLAP database is completely consistent with the data warehouse—and with itself—is to process the entire database. When you process the database, you completely discard all the dimensions and cubes within the database and create new ones. This takes place as a single transaction, which means that client applications can continue to use the existing cubes until processing is complete. It also means that if an error occurs at any point during the processing, the entire change is rolled back, again ensuring that the database is internally consistent.

Processing the entire database is the simplest, cleanest, and best option, provided that you have sufficient time and storage space available. ...

Get Microsoft® SQL Server™ 2000 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.