O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

Choosing Cube and Dimension Processing Options

Now that we've covered storage, aggregations, partitions, and caching, we are ready to review cube and dimensions 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 remember 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