Execute Aggregate Process

Perform an aggregation, optionally specifying the maximum disk space for the resulting files. This statement is only applicable to aggregate storage databases.

This statement causes Analytic Services to

  1. Select 0 or more aggregate views based on the stopping value, if given

  2. Build the views that were selected

For information about aggregate views, see the Database Administrator's Guide and the Administration Services Online Help.

Syntax

Example

execute aggregate process on database Sample.Basic
stopping when total_size exceeds 1.3;

Selects and builds an aggregation of the Sample Basic database that permits the database to grow by no more than 30% as a result of the aggregation.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com