Database Reference
In-Depth Information
Figure 10-44.
Setting the processing options
The Processing Options dropdown box is an important configuration within this window. In the following
list, we discuss each of its settings:
•
Process Default
: Processes only objects that require processing. For example, if you have
successfully processed an individual dimension and then try to process the project as a
whole, the successfully processed dimension will be skipped.
•
Process Full
: Allows you to override all the existing data with fresh data. This is useful
when there may be corruption within your SSAS database that can be resolved with a
complete data reload. An example is when one dimension is out of sync with the others
and the error message is not self-explanatory. If processing fails at the project level and
the reasons are not obvious, first process the dimensions individually and then process
the entire project using the Process Full option. This often clears up the issue.
•
Process Clear:
Cleans out the data within the SSAS database. This can be used to create a
backup of the SSAS database without any data in it.
Process Default is likely all you need, especially in a production environment where processing can take
hours. You would not use the Process Full option unless troubleshooting was necessary.
Once you have selected an option and clicked Run at the bottom of the Process Dialog window, an
additional dialog window called Process Progress will appear, and the processing will truly begin (Figure
10-45
).
