Settings for Enabling and Configuring Incremental Builds

Use these settings to turn on incremental builds, specify the maximum allowed duration of an incremental build per aggregate, and specify the maximum number of partitions per aggregate.

To access these settings:

Restriction: Your user ID must be a super user.

Choose Settings from the main navigation, select Engine. Use your browser Find to search for each setting.

Settings

AGGREGATE.INCREMENTALUPDATE.ENABLED: Set to True to use incremental builds for all of the aggregates for a cube 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 fact tables.
AGGREGATE.INCREMENTALUPDATE.ALLPARTITIONMATERIALIZATIONS.DURATION: Specify the maximum length of time to allow for an incremental build of an aggregate table.
AGGREGATE.INCREMENTALUPDATE.MAXCONSECUTIVESTATICPARTITIONS: Specify the maximum number of partitions to allow for each incrementally built aggregate. When this threshold is exceeded, the partitions are consolidated. Lower values relative to the default result in slower consolidations and faster queries. Higher values result in faster consolidation and slower queries.