Understanding dimension processing options
We must ensure that each dimension referenced, by a particular measure group, has an up-to-date dataset prior to processing any partitions in that measure group. If we attempt to process a measure group before dimensions have up-to-date data, we will encounter missing key errors and the measure group / partition processing will fail.
How it works...
The following table summarizes dimension processing options:
|
Processing option |
Description |
Used for |
|---|---|---|
|
|
This option loads a full dimension dataset and rebuilds all indexes. This option invalidates all partitions referencing the current dimension; every partition will have to be fully reprocessed. |
Each dimension must first be processed using |
Get SQL Server Analysis Services 2012 Cube Development Cookbook 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.
