Dealing with partition processing options
Once you are happy with the dimensions' processed state, it's time to process partitions, measure groups, and cubes.
Although you can process an entire measure group or even an entire cube, those options are rarely used. Instead you're likely to process only the most recent (perhaps daily) partition in each measure group. If you use the ProcessUpdate incremental dimension processing option, you will also need to rebuild indexes on some or all partitions in the affected measure groups.
The following table summarizes partition processing options:
|
Processing option |
Description |
Used for |
|---|---|---|
|
|
This option empties out the partition's contents to "unprocess" it. |
This option could be useful if you're ... |
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.
