Skip to main content
Version: I2023.4.1

Settings that are Related to Narrowing and Widening

Use these settings to enable the narrowing and widening of aggregates. To access them:

  1. Your user ID must be a super user.
  2. Choose Settings from the main navigation, select Engine.
  3. Locate the setting you need.

AGGREGATES.CREATE.NARROWING.ENABLED

Set to True to allow the engine to define new aggregates as narrower versions of existing aggregates when the compression factor is met or exceeded by the new aggregates. Narrower aggregates contain fewer dimensions than their predecessors.

You can set the compression factor with the setting AGGREGATES.CREATE.COMPRESSION.THRESHOLD.

AGGREGATES.CREATE.WIDENING.ENABLED

Set to True to allow the engine to define new aggregates as wider versions of existing aggregates. Wider aggregates contain more measures than their predecessors.

AGGREGATES.WITHDISTINCTCOUNTS.WIDENING.ENABLED

Allows widening of distinct count aggregates with other measures, including distinct counts. This setting requires AGGREGATES.CREATE.WIDENING.ENABLED to be set to True (see above).

Note that this setting is applied per cube. For details, see Cube Level Configuration Settings.

AGGREGATES.CREATE.WIDENING.MEASURE.LIMIT

Specify the maximum number of measures that can be added when widening. This setting requires AGGREGATES.CREATE.WIDENING.ENABLED to be set to True (see above).