Execute Aggregate Process (Aggregate Storage)

Perform an aggregation, optionally specifying the maximum disk space for the resulting files, and optionally basing the view selection on user querying patterns.

This statement applies to aggregate storage databases only.

This statement enables you to build aggregate views with a minimum of settings. If greater control is needed, you can combine the following statements:

This statement causes Essbase to:

Select 0 or more aggregate views based on the stopping value and/or on querying patterns, if given.
Build the views that were selected.

You can also configure Essbase to generate aggregate views automatically. For more information about aggregate views, see Aggregating an Aggregate Storage Database.

Syntax

Description of the illustration execagg.gif

You can aggregate an aggregate storage database in the following ways using execute aggregate process.

Keywords

stopping when total_size exceeds...: Aggregate whichever views Essbase selects, with the exception that the maximum growth of the aggregated database must not exceed the given ratio. For example, if the size of a database is 1 GB, specifying the total size as 1.2 means that the size of the resulting data cannot exceed 20% of 1 GB, for a total size of 1.2 GB.
based on query_data: Aggregate whichever views Essbase selects, based on collected user querying patterns. This option is only available if query tracking is turned on, using alter database with the enable query_tracking grammar.
enable|disable alternate_rollups: If enabled, secondary hierarchies (with default level usage) are considered for view selection. Default: disabled (no secondary hierarchies are considered).

Notes

View selection (step 1) can be performed independently of aggregation by using execute aggregate selection. Aggregation (step 2) can be performed without built-in view selection by using execute aggregate build.

Example

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

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

execute aggregate process on database ASOsamp.Sample based on query_data;

Selects and builds an aggregation of the ASOsamp.Sample database, where the views that Essbase selects for aggregation are based on the most frequently queried areas of the database.