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