Defining Intelligent Cube refresh settings

The Intelligent Cube refresh settings 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. The Intelligent Cube refresh settings are recommended if the data in the Intelligent Cube must be updated for only one attribute, or if updates for multiple attributes must be made simultaneously.

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.

Prerequisites

• 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.

To define Intelligent Cube republish settings

1. Navigate to the Intelligent Cube you want to define republish settings for.

2. Right-click the Intelligent Cube, and select Edit. The Intelligent Cube Editor opens.

3. From the Data menu, select Configure Intelligent Cube. The Intelligent Cube Options dialog box opens.

4. Navigate to the Data Refresh category.

5. Choose one of the following options:

   • Full Refresh: This 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-calculated every time it is updated, and thus must use the Full Refresh option.

     • Dynamic Refresh: The Intelligent Cube's filter is evaluated. If new data is available, it is fetched and added to the Intelligent Cube, and 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 Full Refresh option is used as a fallback.

   • Update: The Intelligent Cube's filter 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. 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.
   • Insert: The Intelligent Cube's filter is evaluated. If new data is available, it is fetched and 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.

6. Click OK to save your changes.