DEFAULTVIEWBUILD

Sets whether default aggregate view selection and materialization are recreated automatically in the following events:

  • when there is a metadata change that would require redesign or rebuilding of aggregate views
  • when aggregate views are removed
  • when data is loaded to an empty cube

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.

If this setting is not enabled, default aggregate views are created by Essbase using internal analysis based on data sampling.

Syntax

DEFAULTVIEWBUILD appname TRUE | FALSE
  • appname—Application name. The configuration applies to all cubes within the named application.

  • TRUE—Aggregate view selection and materialization are automated.

  • FALSE—Aggregate view selection and materialization are not automated.

Example

DEFAULTVIEWBUILD TRUE