Cube and Dimension Processing Options

Now that we’ve covered storage, aggregations, partitions, and caching, we’re (finally!) ready to review cube and dimension processing option types. Dimensions must be completely and correctly processed either prior to or at the beginning of a cube process. The best way to understand this is to keep in mind that dimensional data is the metadata or the structure of the cube itself. So the metadata must be available before the data can be loaded into the cube.

During development, you will most often do a full process on your cube whenever you need to view the results of a change that you’ve made. This option completely erases and rebuilds all data and metadata. For some customers, this simple method of updating ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

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