METADATABASEDAGGVIEWSBUILD

This Essbase configuration setting enables you to select whether default view maintenance is automated, and to select the view selection algorithm Essbase should use.

This configuration applies only to aggregate storage cubes.

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. In some cases, the new algorithm is better for query performance.

Note: In Release 21C or later, this configuration replaces DEFAULTVIEWBUILD.

Syntax

METADATABASEDAGGVIEWSBUILD appname OFF | ON | AUTO

appname—Application name. The configuration applies to all cubes within the named application. If unspecified, the configuration applies to all aggregate storage cubes on the Essbase Server.
OFF—This is the default. Creation and maintenance of default aggregate views are not automated. Instead, you select, build, and maintain the aggregate views yourself. For its view selection algorithm, Essbase uses internal analysis based on data sampling.
ON—Creation of default aggregate views is not automated. For its view selection algorithm, Essbase uses database metadata analysis.
AUTO—Essbase performs automatic default aggregate views selection, build, and maintenance, meaning that default aggregate view selection and materialization are recreated automatically in response to the following qualifying cube events:
- data is updated (loaded, calculated, allocated, deleted, or submitted from Smart View)
- there is a metadata change that would cause an update of data indexes, requiring a redesign or rebuilding of aggregate views
The AUTO setting is not supported if your cube uses custom calculations and allocations.

For its view selection algorithm, Essbase uses database metadata analysis.

Use DEFAULTVIEWBUILDSIZE to limit the growth of cubes as a result of automatic views maintenance.

Example

METADATABASEDAGGVIEWSBUILD AUTO