Version 2021

About defining an incremental refresh filter or report

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.

For example, an Intelligent Cube contains monthly sales data for 2019 and 2020 for year-on-year comparison. Once the year 2021 begins, you only need to keep the data for 2020, and the data for 2019 can be removed from the Intelligent Cube. You can define one incremental refresh that runs at the end of every month, and adds that month's data to the Intelligent Cube, and a second incremental refresh that deletes the previous year's data at the end of every year.

You can also define incremental refreshes to add data for other dimensions, such as Country. For example, you have an Intelligent Cube that contains data for the USA, UK, and France, and you want to add data for Germany. You can define an incremental refresh that fetches all the data for Germany and adds it to the cube.

You can define incremental refreshes using filters or reports, as described below:

  • Filter: The data returned by a filter is compared to the data that is already in the cube. By default, the filter defined for the Intelligent Cube is used as the filter for the incremental refresh. For information, see Defining an incremental refresh filter.

  • Report: The results of a report are used to populate the Intelligent Cube. By default, the report template used is the same as the Intelligent Cube's template. For information, see Defining an incremental refresh report.