Generate Aggregate Views Automatically

You can create aggregate views to be generated automatically, according to the dimension structure in an outline for an aggregate storage cube.

If you add the application configuration setting DEFAULTVIEWBUILD and set it to TRUE, aggregation views will be generated automatically after each data load to an empty cube, after changes to metadata that require redesign or rebuild of aggregate views, or on-demand (when the execute aggregate selection MaxL statement is run).

When you use automatically generated aggregation views, query performance can improve. It may impact data load time and increase the amount of disk space used by data.

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.