DEFAULTVIEWBUILDSIZE

Sets the maximum allowed cube growth ratio when aggregate view selection and materialization are automated.

This configuration applies only to aggregate storage cubes, when DEFAULTVIEWBUILD configuration is set to TRUE.

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 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