Optimizing Dimension and Cube Processing - SQL Server Analysis Services 2012 Cube Development - page 180

Processing option Description Used for

This option creates in-
dexes and aggregations
on a partition that already
has the full dataset.

This option is necessary
after running ProcessUp-
date on dimensions. This
option could also be required
in the case of sparse
memory resources.

ProcessIndexes

ProcessClearIndexes This option drops existing
indexes and aggregations
without deleting data.

This option is useful after
you change the aggregation
design and would like to use
a new set of aggregations.
This option must follow up
with ProcessIndexes to
build the new aggregations.

This option brings the par-
tition from its current state
into a fully-processed
state.

This option is used only if
finer control on the partition
processing isn't required.

ProcessDefault

How to do it...

To process a partition, perform the following steps:

1. Select an existing partition by expanding cubes, measure groups, and par-
titions' folders within SSMS. Right-click and choose Process . You can pro-
cess multiple partitions by opening Object Explorer Details , by pressing F7
within SSMS, then selecting desired partitions, right-clicking and choosing
Process .