Incremental Refresh Options, General

The options below allow you to define the behavior of the incremental refresh when it is executed. You can also configure the incremental refresh to update more than one Intelligent Cube.

Target Intelligent Cube

You can configure the incremental refresh to update a different Intelligent Cube, under the following conditions:

• If you are using a filter to refresh the Intelligent Cube, the attributes in the filter must be present on the new Intelligent Cube.
• If you are using a report to refresh the Intelligent Cube, the report's template must have the same attributes as the new Intelligent Cube, and must have at least one metric in common.

Refresh type

Use the following options to select the behavior of the incremental refresh.

• Update: The incremental refresh filter or report is evaluated. If new data is available, it is fetched and added to the Intelligent Cube, and if the data returned is already in the Intelligent Cube, it is updated where applicable.
• Insert: The incremental refresh filter or report is evaluated. If new data is available, it is fetched and added to the Intelligent Cube. Data that was already in the Intelligent Cube is not altered.
• Delete: The incremental refresh filter or report is evaluated. The data that meets the filter or report's definition is deleted from the cube. For example, if the Intelligent Cube contains data for 2018, 2019, and 2020, and the filter or report returns data for 2018, all the data for 2018 is deleted from the cube.
• Update only: The incremental refresh filter or report is evaluated. If the data available is already in the Intelligent Cube, it is updated where applicable. No new data is added to the Intelligent Cube.
• Replace: The incremental refresh filter is evaluated. Old cube data that meets the filter definition is deleted and replaced with new data. Your metadata must be upgraded to MicroStrategy 2021 or above to use this option. This option only works with incremental refresh filters and not reports.