Execute Aggregate Process (Aggregate Storage)
The MaxL execute aggregate process statement helps you perform an aggregation on an Essbase aggregate storage database.
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.
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.Basic
stopping when total_size exceeds 1.3;Selects and builds an aggregation of the ASOsamp.Basic database that permits the database 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 database, where the views that Essbase selects for aggregation are based on the most frequently queried areas of the database.