Skip to main content

Aggregate Incremental Builds Settings

You can use the following settings to configure incremental aggregate builds at the model level.

  • aggregate.incrementalUpdate.enabled: Set to True (default) to use incremental builds for all of the aggregates for a model when the fact dataset uses an incremental indicator. Full builds are still done for user-defined aggregates that are joins or unions of two or more tables.
  • aggregate.incrementalUpdate.indicatorLookup.addPreviousMaxConstraint: Whether or not to use the previous MAX value of the indicator as a constraint to improve performance. The default value is True.
  • aggregate.incrementalUpdate.indicatorLookup.duration: Maximum time allowed to lookup incremental indicator. The default value is 30 minutes.
  • aggregate.incrementalUpdate.indicatorLookup.reusePerBatch: Whether or not to use the same max indicator lookup per batch per indicator to improve performance. The default value is True.
  • aggregate.incrementalUpdates.immutable.enabled: Set to True (default) to enable incremental builds of aggregates that use joins on rarely changing dimensions.
  • aggregate.incrementalUpdates.semiAdditive.enabled: Set to True to enable support for incremental updates on semi-additive metrics. The default value is False.

More information

Model Level Configuration Settings