DEFAULTVIEWBUILDSIZE

This Essbase configuration setting specifies the maximum allowed cube growth ratio when aggregate view selection and materialization are automated.

This configuration applies only to aggregate storage cubes, when METADATABASEDAGGVIEWSBUILD is set to ON or AUTO (in Release 21C or later), or when DEFAULTVIEWBUILD configuration is set to TRUE (in releases prior to 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