Updating Intelligent Cubes using schedules

While you are creating or modifying an Intelligent Cube, you can schedule when an Intelligent Cube should be re-executed against the data warehouse to update its data. For example, you can schedule to re-execute and republish an Intelligent Cube when a database load occurs.

The procedure below describes the steps to create a subscription that schedules the re-execution and republication of a single Intelligent Cube. You can also schedule multiple Intelligent Cubes to be updated using a single subscription, which is described in Publishing Intelligent Cubes using a schedule.

Prerequisites

An Intelligent Cube has been created.

To schedule an Intelligent Cube to be updated

1. In MicroStrategy Developer, browse to an Intelligent Cube.

2. Right-click the Intelligent Cube, point to Schedule Delivery To, and then select Update Cube. The Subscription Editor opens.

3. Select a schedule from the Schedule drop-down list.

4. Select other schedule options as required, and click OK. The Subscription Editor closes and you are returned to MicroStrategy Developer.

Once the schedule is triggered the Intelligent Cube is re-executed against the data warehouse and published to the Cube Monitor.