Version 2021

Updating Intelligent Cubes without re-processing: Incremental Refresh

By default, if the data in an Intelligent Cube needs to be updated, it is re-executed. All the data for the Intelligent Cube is loaded from the data warehouse into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten.

However, if the Intelligent Cube is updated based on one or more attributes, such as Month or Region, you can set up incremental refresh settings to update the Intelligent Cube with only new data. This can reduce the time and system resources necessary to update the Intelligent Cube periodically.

For example, you have an Intelligent Cube that contains weekly sales data. At the end of every week, this Intelligent Cube must be updated with the sales data for that week. You can set up incremental refresh settings so that only data for one week is added to the Intelligent Cube.

Prerequisites

For an Intelligent Cube to qualify for an incremental refresh, it must meet the following requirements:

  • The updates to the Intelligent Cube must be according to attributes only.
  • For example, an Intelligent Cube that must be updated with data for a month or region qualifies for an incremental refresh.
  • The Intelligent Cube must not be re-processed based on a metric.
  • For example, an Intelligent Cube that contains data for the top 200 stores by Revenue does not qualify for an incremental refresh.