Aggregating Data

Calculate aggregations for aggregate storage databases that contain data and to which you are granted Calculation permission.

To perform an aggregation, you use system recommended views. The selection of views and aggregation processes are combined into one, non-configurable operation performed by the server. You can optionally specify the maximum disk space for the resulting files, base the view selection on user querying patterns, and include rollup hierarchies in the view selection.

Note:

You can aggregate data for aggregate storage databases only. For an example of best practices when aggregating data, see Executing the Aggregation Process.

To perform an aggregation:

1. In System View, click
2. In Enterprise View, right-click the plan type that contains the database whose outline you want to compact, and then select Execute Aggregation.
3. In the Execute Aggregation Action - Use Recommended Views dialog box, select one of the following options:

   • Based on query data?—Aggregate the views the server selects, based on collected user querying patterns. This option is only available if query tracking is turned on.

   • Include rollup option?—Include secondary hierarchies (with default level usage) in the view selection process.

   • Include growth size option?—Aggregate the views the server selects, until the maximum growth of the aggregated database exceeds limits you specify. Enter the size (in megabytes) beyond which the server should stop the aggregation.

4. Click OK.

   If existing aggregation data exists, a message is displayed asking if you want to delete existing aggregations and rerun the aggregation process. If existing data exists, it is deleted before the aggregation process is rerun.

5. Click OK to delete existing aggregation data and rerun the aggregation.