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