MicroStrategy ONE

Refresh Cubes

MicroStrategy ONE (December 2024) adds the ability to refresh multiple cubes from the Intelligent Cube Monitor and Datasets pages.

Starting in MicroStrategy ONE (September 2024), you can perform a single cube refresh for OLAP and MTDI cubes.

Refresh your cubes and datasets to replace the dataset rather than republish it to assure that data structure changes (such as removing or adding columns in a spreadsheet) are made in the dashboard's dataset .

Prerequisites

To refresh cubes from Monitors, you need the following privileges:

  • Monitor Cubes

  • Monitor Cluster

  • Publish Intelligent Cube

  • Web Publish Intelligent Cube

To refresh cubes from Datasets, you need the following privileges:

  • Publish Intelligent Cube

  • Web Publish Intelligent Cube

Refresh a Single Cube in Datasets or Monitors

  1. Open the Workstation window with the Navigation pane in smart mode.
  2. In the Navigation pane, click Environments.

  3. Log into your environment.

  4. In the Navigation pane, click Monitors and in the left panel, click Caches. Ensure Cubes is selected in the top toggle.

    or

    In the Navigation pane, click Datasets.

  5. Right-click a cube and choose Refresh Cube....

  6. Select one of the following options:

    • Refresh Data with Configured Refresh Type (Replace): Choose this option to update the existing data.

    • Use an Incremental Refresh Report: Choose this option to use a report to refresh your data. Choose a refresh report from the drop-down list or click New Incremental Refresh Report to create a new report.

      For more information, see Create Incremental Refresh Reports (IRRs).

  7. Click Refresh.

    A confirmation message displays.

  8. To check that your refresh was successful:

    1. If you are not already on the Monitor page, in the Navigation pane, click Monitors.

    2. Click Caches. Ensure Cubes is selected in the top toggle.

    3. Check the Last Refresh Status and Last Refreshed columns of your cube to ensure your refresh was successful.

Refresh Multiple Cubes in Datasets or Monitors

  1. Open the Workstation window with the Navigation pane in smart mode.
  2. In the Navigation pane, click Environments.

  3. Log into your environment.

  4. In the Navigation pane, click Monitors and in the left panel, click Caches. Ensure Cubes is selected in the top toggle.

    or

    In the Navigation pane, click Datasets.

  5. Select the check box next to the cubes you want to refresh.

  6. Right-click a cube and choose Refresh.

  7. Confirm the list of cubes and datasets to refresh is correct.

  8. Click Refresh.

  9. To check that your refresh was successful:

    1. If you are not already on the Monitor page, in the Navigation pane, click Monitors.

    2. Click Caches. Ensure Cubes is selected in the top toggle.

    3. Check the Last Refresh Status and Last Refreshed columns of your cubes to ensure your refresh was successful.

Related Topics

Monitor Intelligent Cubes

Create Incremental Refresh Reports (IRRs)

Republish Datasets