DEFAULTVIEWBUILD

This configuration setting applies only to aggregate storage cubes in releases prior to Release 21C, and controls whether you want Essbase to 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. In some cases, the new algorithm is better for query performance.

Note: In Release 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