Starting in MicroStrategy 2021 Update 6, you can use REST API requests retrieve, create, and update the Incremental Refresh Report (IRR) objects through the Modeling service.
- Retrieve an IRR definition
- Create an IRR
- Update an IRR definition
- Retrieve an IRR definition with advanced properties
- Create an IRR with advanced properties
- Update IRR advanced properties
- Retrieve an IRR's applicable properties
This section outlines the important fields in the API response body defined for an Incremental Refresh Report.
Stores the basic information for the Incremental Refresh Report including
For Incremental Refresh Report,
name for the target cube that the Incremental Refresh Report is built on. This is required when creating a new Incremental Refresh Report.
For target cube,
Specifies the incremental type for an Incremental Refresh Report, which can only be
Specifies the refresh type for an Incremental Refresh Report, which can only be
refreshType is only supported for the
incrementType filter of the Incremental Refresh Report.
Stores the information for the filter used in the Incremental Refresh Report, which has the same structure as a filter object.
An Incremental Refresh Report filter is presented in the following formats:
text: A human readable, but non-parsable text, describing a filter's qualification.
tree: A tree data structure fully defining the filter's qualification.
tokens: A list of parsed tokens that define a filter's qualification. Note that generating tokens requires additional time.
showFilterTokens is omitted or
tree formats are returned.
tokens formats are returned.
Stores the information of the template used in the Incremental Refresh Report, which includes rows, columns and pageBy.
incrementType of the Incremental Refresh Report is
filter, it’s not allowed to modify the template.
For more information about the Modeling service, see Configuring the Modeling Service.