Process a Cube Dialog Box

Analysis Services

Analysis Services

Process a Cube Dialog Box

Use this dialog box to choose how to process a cube.

This dialog box appears when you right-click a cube in the Analysis Manager tree pane, and then click Process.

Options

Incremental update

Select to append new data from the data warehouse to one of your cube's partitions and update aggregations. An incremental update does not affect the existing data that has already been processed and usually requires significantly less time than processing with the Process option.

An incremental update can be performed while users continue to query the cube; after the update has completed, users will have access to the additional data without having to reconnect.

This option is not applicable if the cube's structure has changed, or if the data from which the cube was created has changed.

Caution  This option updates a partition. Incorrect use of partitions can result in inaccurate cube data. For more information, see Managing Partitions.

Refresh data

Select to cause the cube's data to be cleared and reloaded and aggregations recalculated. This option is applicable when the underlying data in the data warehouse has changed but the cube's structure remains the same.

A refresh can be performed while users continue to query the cube; after the refresh has completed, users will have access to the refreshed data without having to reconnect.

Full Process

Select to completely rebuild your cube after you have made structural changes to it, such as adding a dimension, dimension level, or measure. This option restructures the cube based on its current definition and recalculates and reloads its data. This option can take a long time.

After you process a cube with this option, users must reconnect to the server computer to continue working with the cube.

If a shared dimension's structure is updated and saved but not processed, it will automatically be processed when any cube incorporating the dimension is processed with this option. At that time any other cubes that incorporate the dimension immediately become unavailable to users and must be processed before they can be used again.

Incrementally update the dimensions of this cube

Select to enable incremental updating of the cube's shared and private dimensions whenever the cube is processed.

Settings

Click to display the Cube Processing Settings Dialog Box, where you can specify additional cube processing options.

See Also

Cube Processing Settings Dialog Box

Processing Cubes