Process a Cube Dialog Box

Enables you to choose how to process a cube.

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

Options

Incremental update

Select this option 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 Partitions and its subtopics in the Administrator’s Guide.


Refresh data

Select this option 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.

Process

Select this option 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 definitions 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.


Caution 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.


OK

Starts the operation you have chosen.

Cancel

Cancels the dialog box without processing the cube.

Help

Displays this topic in Help.

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.