MicroStrategy ONE

Intelligent Cube Options, Data Refresh

The republish settings below change the way the Intelligent Cube is updated when you re-execute it manually, or when it is published on a schedule, as described in Publishing Intelligent Cubes using a schedule.

For complex update requirements, such as updating an Intelligent Cube for different dimensions at different intervals, you can define an incremental refresh filter or report to update your Intelligent Cube, as described in About defining an incremental refresh filter or report.

The options you can choose are described below.

Full Refresh

The Full Refresh option is the default. The Intelligent Cube's SQL is re-executed, and all the data is loaded from the data warehouse into Intelligence Server's memory. Use this option under the following conditions:

  • If the data in the Intelligent Cube is outdated.

  • If the Intelligent Cube must be re-processed based on a metric. For example, an Intelligent Cube that contains data for the top 200 stores by Profit must be re-processed every time it is updated, and thus must use the Full refresh option.

Incremental Refresh options

The incremental refresh options allow you to update the Intelligent Cube with only new data. This can reduce the time and system resources necessary to update the Intelligent Cube.

In order to use the incremental refresh options, the Intelligent Cube's definition must include a filter that is based on the attributes for which the Intelligent Cube must be updated. For example, if the Intelligent Cube must be updated with new data for the Store attribute, the filter must qualify on Store.

The options available are as follows:

  • Dynamic Refresh: The Intelligent Cube's filter is evaluated. If new data is returned, it is added to the Intelligent Cube. Data that no longer meets the filter's criteria is deleted from the Intelligent Cube. Select this option for Intelligent Cubes that have a rolling set of data—for example, an Intelligent Cube that always contains data for the past six months.

    If the data to be added and deleted cannot be determined, the Intelligent Cube is re-executed.

  • Update: The Intelligent Cube's filter is evaluated. If new data is returned, it is added to the Intelligent Cube, and if the data returned is already in the Intelligent Cube, it is updated where applicable. Select this option if your data is updated often—for example, an Intelligent Cube that contains daily sales data, and is updated at the end of every day, or if you are adding data to an Intelligent Cube created using the Import Data feature.

  • Insert: The Intelligent Cube's filter is evaluated. If new data is returned, it is added to the Intelligent Cube. Data that is already in the Intelligent Cube is not altered. Select this option if old data does not change once it is saved to your data warehouse.