Usage-Based Optimization Wizard - Aggregations Already Exist

This step of the wizard appears only if there are previously designed aggregations for your cube or partition. Information appears on the screen about the existing data storage and aggregation settings.

Settings

Data storage type

Displays the data storage type used in this cube partition.

Aggregation storage space

Displays the existing storage space used by the previously designed aggregations in this cube partition.

Number of aggregations

Displays the number of aggregations previously designed for this cube partition.

Options

Replace the existing aggregations

Select this option to completely replace the existing aggregations with new ones you design. Before you can use your new aggregations, you must reprocess the cube.

Add new aggregations to the existing ones

Select this option to append new aggregations to the existing ones. You must reprocess the cube to use combined aggregations for this cube partition.

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