Execute Aggregate Process (Aggregate Storage)
The MaxL execute aggregate process statement helps you perform an aggregation on an Essbase aggregate storage (ASO) cube.
The minimum application permission required to perform an ASO aggregation is Application Manager.
Use this statement to perform an aggregation. Optionally, you can specify the maximum disk space for the resulting files. Optionally, you can base the view selection on user querying patterns.
This statement applies to aggregate storage cubes only.
The execute aggregate process statement enables you to build ASO aggregate views with a minimum of interactive settings. If greater control is needed, you can instead combine the following statements to select and materialize the aggregations:
When you run execute aggregate process on an ASO cube, it 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, refer to Aggregating an Aggregate Storage Database.
Keywords
You can explicitly initiate an aggregation of an ASO cube in the following ways using MaxL execute aggregate process.
- execute aggregate process … stopping when total_size exceeds...
-
Aggregate whichever views Essbase selects, with the exception that the maximum growth of the aggregated cube must not exceed the given ratio. For example, if the size of a cube 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.
- execute aggregate process … 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.
- execute aggregate process … enable|disable alternate_rollups
-
If enabled, secondary hierarchies (with default level usage) are considered for view selection. By default, 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.
Examples
execute aggregate process on database ASOsamp.Basic
stopping when total_size exceeds 1.3;Selects and builds an aggregation of the ASOsamp.Basic cube that permits the cube to grow by no more than 30% as a result of the aggregation.
execute aggregate process on database ASOsamp.Basic based on query_data;Selects and builds an aggregation of the ASOsamp.Basic cube, where the views that Essbase selects for aggregation are based on the most frequently queried areas of the cube.