DEFAULTVIEWBUILD

This configuration setting applies only to aggregate storage (ASO) cubes in Essbase 19c, when you want Essbase to automate the creation and maintenance of default aggregate views.

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 is replaced by METADATABASEDAGGVIEWSBUILD.

This configuration applies only to aggregate storage cubes. Use the DEFAULTVIEWBUILDSIZE configuration setting to limit the growth of cubes as of a result of automatic aggregations.

Syntax

DEFAULTVIEWBUILD appname TRUE | FALSE

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.
TRUE—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
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.
FALSE—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.

Example

DEFAULTVIEWBUILD TRUE