Generate Aggregate Views Automatically

For aggregate storage cubes, you can automate the creation and maintenance of default aggregate views.

In Essbase releases prior to 19C, default aggregate views were created by Essbase using internal analysis based on data sampling. Starting in Release 19C, a new algorithm is used for selecting default views, based on database metadata analysis.

If you use the view-selection algorithm based on database metadata analysis, it enables Essbase to perform automatic default aggregate views selection, build, and maintenance. When you select to use automatically generated aggregation views, query performance can improve. It also impacts data load time and increases the amount of disk space used by data, because right after a data load, aggregate views will be built (or updated, in the case of existing views).

To automate default aggregate view generation and management, set the METADATABASEDAGGVIEWSBUILD configuration to AUTO (in Release 21C or later), or set the DEFAULTVIEWBUILD configuration to TRUE (in Release 19C). If enabled, aggregation views will be generated automatically based on qualifying criteria, or on-demand (when the execute aggregate selection MaxL statement is run).

For details about the qualifying criteria, see METADATABASEDAGGVIEWSBUILD (for 21C) or DEFAULTVIEWBUILD (for earlier releases).

To control the size of the resulting aggregate views, add the additional application configuration setting DEFAULTVIEWBUILDSIZE, and set its value to the desired total size ratio. For example, DEFAULTVIEWBUILDSIZE AsoSamp 1.2 limits the resulting growth of the aggregated cube to no more than 20% of its size prior to the aggregation.