O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

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 ...

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