MicroStrategy ONE

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.

    Update Adds new data if it does not already exist in the Intelligent cube. If there are matches, it updates the values where applicable.

    Insert Adds only new data fetched by the incremental refresh report to the Intelligent cube, without altering data already existing in the cube

    Delete Removes existing data from the Intelligent cube if it matches the criteria in the definition of the incremental refresh report.

    Update Only Replaces the existing Intelligent cube. This option does not add new data to the Intelligent cube.

    Replace Available for incremental refresh filters

  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.