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 ...
Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
