Refresh cubes from an automation

Use Refresh cubes after data changes when updated reporting values required.


Example: Update reporting after business case approval

Scenario: Business case status changed, but reports may still show previous values.

  1. Add Refresh cubes after successful write or status change.

  2. Select BusinessCaseDetails and other cubes required by affected reports.

  3. Enable Only pending partitions to refresh changed partitions; leave unchecked for full rebuild.

  4. Check Admin > Cube refresh for completion. Refresh step queues work but does not wait.


Configure refresh

  1. In automation Builder, select + Add step > Refresh cubes.

  2. Under Cubes, select one or more cubes.

  3. Enable Only pending partitions to refresh changed partitions only. Leave disabled to rebuild every selected cube in full.

  4. Save and Test run.


Important behavior

Refresh request is queued, not waited on. Automation proceeds immediately; report step later in same run may still show old values.

Check progress and failures under Admin > Cube refresh. No notification sent automatically from this step.

For workflows requiring freshly rebuilt data, verify refresh completion before relying on reporting output.