Publishing Intelligent Cubes using a schedule

As an alternative to manually publishing Intelligent Cubes, you can schedule the publication of Intelligent Cubes to occur at a time when the load on your Intelligence Server and data warehouse is low. This allows you to publish Intelligent Cubes without affecting performance time of Intelligence Server during peak usage.

You can also schedule the publication of Intelligent Cubes to update Intelligent Cube data when events occur that would make the Intelligent Cube data outdated. For example, you can schedule to republish an Intelligent Cube when a database load occurs. The procedure below creates a subscription that can schedule multiple Intelligent Cubes to be updated. Alternatively, you can define an Intelligent Cube to be updated on a schedule during Intelligent Cube creation, which is described in Updating Intelligent Cubes using schedules.

You schedule an Intelligent Cube for publication by creating a subscription for the Intelligent Cube. The procedure below provides steps to create a subscription to schedule the publication of an Intelligent Cube.

The act of publishing an Intelligent Cube can require memory resources approximately two times greater than the size of an Intelligent Cube. This can affect performance of your Intelligence Server as well as the ability to publish the Intelligent Cube. To plan for these memory requirements, see the System Administration Help.

Prerequisites

• An Intelligent Cube has been created.

• You have created the schedule. You can now subscribe an Intelligent Cube publication using this schedule. For information on creating schedules, see the System Administration Help.

To schedule the publication of Intelligent Cubes

1. In MicroStrategy Developer, log in to a project source using administrative privileges.

2. From the Administration menu, point to Scheduling, and then select Subscription Creation Wizard. The Subscription Creation Wizard opens.

3. If the welcome page is shown, review the information and click Next.

4. On the Subscription Wizard - Specify Characters page, begin defining the subscription using the following drop-down lists:

   • Choose a schedule for this set of subscriptions: Select a schedule to trigger the publication of Intelligent Cubes. A schedule can be time- or event-triggered.

   • Choose a project from which reports/documents will be delivered to the recipients: Select a project that contains Intelligent Cubes to schedule for publication. When publishing Intelligent Cubes, the Intelligent Cubes are not delivered to a specific recipient, they are instead published to the Intelligent Cube Monitor.

   • Choose a Delivery Type: Select Cube Update. This delivery type publishes Intelligent Cubes to the Intelligent Cube Monitor.

5. Click Next. The Subscription Wizard - Choose Reports/Documents page opens.

6. In the Available objects pane, browse to and select Intelligent Cubes to schedule for publication. Once selected, click the right arrow (>) to move any selected Intelligent Cubes to the Selected objects pane.

7. Click Next. The Subscription Wizard - Choose Recipients page opens.

8. Keep the default user that is selected or select a different user with administrative privileges, and click Next. The Subscription Wizard - Specify Subscription Properties page opens.

9. You can choose from the following subscription properties:

   • Run subscription immediately: Select this check box if the Intelligent Cube should be published immediately. This causes any Intelligent Cubes included in the subscription to be published immediately. The Intelligent Cubes will also be re-published based on the schedule used in the subscription.

   • Expire subscription on: Select this check box if the subscription should expire. If you select an expiration date, the subscription is deleted on that date and Intelligent Cubes included in the subscription are no longer scheduled for publication. The Intelligent Cubes can be published manually.

10. Click Next. The Subscription Wizard - Summary page opens.

11. Review the summary information, and click Finish to create the subscription. If you selected to run the subscription immediately, the Intelligent Cubes are executed against the data warehouse and published to the Intelligent Cube Monitor.

You can view and edit the new subscription from the Subscription Manager. For example, you can select a different schedule to use for the subscription or modify the expiration date for the subscription. For information on subscriptions and the Subscription Manager, see the System Administration Help.