MicroStrategy ONE

About incremental refresh

By default, if the data in an Intelligent Cube needs to be updated, it needs to be re-executed, either manually or using a schedule—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, for example, 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, without affecting the existing data.

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 based on attributes only. For example, an Intelligent Cube that must be updated with data for a specific Month 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.

For instructions to define incremental refresh settings, see: