Specifying incremental refresh options for an Intelligent Cube

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 source into Intelligence Server's memory, and the existing data for the Intelligent Cube is overwritten. You can set up incremental refresh settings to update the Intelligent Cube with only new data when the Intelligent Cube is republished or updated according to a schedule. This can reduce the time and system resources necessary to update the Intelligent Cube periodically.

To specify incremental refresh settings for an Intelligent Cube:

Navigate to the location of the Intelligent Cube you want to edit.
Right-click the name of the Intelligent Cube, then select Edit.
If the original data source was a file that was uploaded from your computer or network, you must reupload the file. Perform the following steps:
1. Click Browse. The Select a File to Upload dialog box is displayed.
2. Navigate to and select the file you want to upload, then click Open. Click Next.
Click the Data Refresh Options icon . The Options - Data Refresh dialog box opens. Select one of the following options to determine how your data will be updated when the Intelligent Cube is run:
- To re-execute the Intelligent Cube and overwrite any existing data, select Replace existing data.
- To update the existing data in the Intelligent Cube, as well as add new data that was not previously included in the Intelligent Cube, select Update existing data and add new data.
- To update the Intelligent Cube only with new data that was not previously included in the Intelligent Cube, select Keep existing data and add new data.
Click Publish to save your changes.