Version 2021

Create Incremental Refresh Reports (IRRs)

Starting in MicroStrategy 2021 Update 6, you can use incremental refresh reports to update data in an Intelligent cube

To use, create, and edit IRRs, you must at least have the following privileges respectively:

  • Client-Web: Web use metric editor

  • Server-Intelligence: Create application objects

  1. Open the Workstation window.
  2. In the Navigation pane, click Datasets and locate the cube where you want to update data.

  3. Right-click the cube and choose Intelligent Cube > Define Incremental Refresh Report.

  4. In Refresh Type, select the refresh method.

  5. You can modify the filter definition by adding qualifications to the Filter panel.

  6. To see the objects included in the cube definiton, go to the Objects pane and click In Cube.

  7. Click Save And Preview.

  8. To view the SQL to be executed, click SQL Query at the top.