Strategy ONE
Dynamic sourcing for incrementally refreshed Intelligent Cubes
Apart from the best practices listed above, additional considerations apply when you are using Intelligent Cubes that are incrementally refreshed. For information on incrementally refreshing Intelligent Cubes, see Updating Intelligent Cubes without re-processing: Incremental Refresh.
Intelligent Cube refresh options supported for dynamic sourcing
The following Intelligent Cube refresh options are supported for dynamic sourcing:
- Full refresh
- Dynamic refresh
- Insert and Update, only if data is being updated for one attribute form
For information on Intelligent Cube refresh settings, see Defining Intelligent Cube refresh settings.
Incremental refresh types supported for dynamic sourcing
You can create an incremental refresh filter or report to refresh the data in an Intelligent Cube. If the Intelligent Cube is refreshed using a filter, the following increment types are supported:
- Update Only
- Insert, Update and Delete, only if the data is being updated for one attribute form
If the Intelligent Cube is refreshed using an incremental refresh report, it cannot be used for dynamic sourcing. For information on incremental refresh filters and reports, see Defining an incremental refresh filter or report.