WhereScape RED generates update procedures for aggregates that are incremental. Incremental updates are based on a date dimension key and number of look back days.
The aggregate update process looks at any records that have been updated in the fact table in the last number of look back days.
The default number of look back days is 7. The default is set in each update procedure. To change the number of look back days for an aggregate table, create a WhereScape RED parameter called AggregateName_lookback and enter the required number of look back days as the parameter value.
For example, add the following parameter to change the look back days to 5 for agg_sa_product:
Refer to Parameters for more information on WhereScape RED parameters.