DEFAULTVIEWBUILDSIZE

This configuration setting enables you to specify the maximum allowed growth ratio of the aggregate storage (ASO) cube when you allow Essbase to automatically maintain default aggregate view selection and materialization.

This configuration applies only to aggregate storage cubes for which METADATABASEDAGGVIEWSBUILD is set to ON or AUTO (in Essbase 21c or later), or when DEFAULTVIEWBUILD configuration is set to TRUE (in releases prior to Essbase 21c).

Syntax

DEFAULTVIEWBUILDSIZE appname n

appname—Application name. The configuration applies to all cubes within the named application.
n—Total size ratio limiting the resulting aggregation views when METADATABASEDAGGVIEWSBUILD (or DEFAULTVIEWBUILD) configuration is enabled. The maximum growth of the aggregated cube must not exceed this ratio. For example, setting the the total size ratio to 1.3 means that the cube can grow by no more than 30% as a result of the automated aggregation.

Example

DEFAULTVIEWBUILDSIZE ASOSamp 1.3