METADATABASEDAGGVIEWSBUILD

This configuration setting enables you to select whether Essbase automatically maintains default views for aggregate storage cubes, and to select the view selection algorithm Essbase should use.

In releases prior to Essbase 19c, Essbase created default aggregate views by using internal analysis based on data sampling. Starting in Essbase 19c, default view selection can be based on metadata analysis. In some cases, this algorithm is better for query performance.

Note: In Essbase 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 view 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 metadata analysis.

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

Example

METADATABASEDAGGVIEWSBUILD AUTO