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

Processing op-
tion Description Used for

This option
empties a di-
mension ob-
ject's contents
to "unprocess"
the dimension.

This option is sometimes necessary if you
reach a 4 GB string store limit (applicable to
SSAS versions prior to 2012), and the Pro-
cessUpdate option fails to complete. In this
case, use ProcessClear followed by Pro-
cessFull , after ensuring that you use the
smallest data type possible for each attribute
and that you only load the data values neces-
sary for analytics.

ProcessClear

This option
loads a full
dataset into a
previously un-
processed di-
mension
without build-
ing indexes.

This option is sometimes useful for 32-bit sys-
tems that are short on memory, to ensure the
processing of a very large dimension com-
pletely, without exhausting all memory.

ProcessData

ProcessIndexes This option re-
builds indexes
on a dimen-
sion after it
has been pop-
ulated with a
full dataset.

This option is used for same scenarios as the
ProcessData option.