Scheduling updates for an Intelligent Cube created using imported data

Once you import data from a file, database, or Salesforce.com report, you can use attributes and metrics defined from this data to create reports and documents in Web. When the data is imported and published, it is published as an Intelligent Cube. You can choose to update this Intelligent Cube based on a specific schedule, to make sure that the report objects in the Intelligent Cube are up-to-date based on the data in your data source. To have an Intelligent Cube updated on a specific schedule, you must create a subscription to send the Intelligent Cube to the History List. The Intelligent Cube is then republished according to the schedule you selected.

For background information on Intelligent Cubes, see the OLAP Services Guide.

Prerequisites

To schedule updates for the Intelligent Cube

  1. Navigate to the folder location of the Intelligent Cube.

  2. Hover the pointer over the Intelligent Cube, and click the Subscriptions icon for the Intelligent Cube. A list of your subscriptions for the Intelligent Cube is displayed.

  3. Click Add History List Subscription. The Subscription dialog box opens.

  4. Type a name for the subscription in the Name field.

  5. From the Schedule drop-down list, select the frequency with which you want to update the Intelligent Cube. You can create a new schedule in the Desktop Schedule Manager. For steps, see the Desktop Help.

  6. Click To. The Recipients Browser dialog box is displayed. Use the right arrow > to add recipients to the To list. Your own user name is automatically added to the To list by default.

  7. Click OK to return to the Subscription dialog box.

  8. Do one of the following:

  9. Click the Show icon Show icon to expand the Advanced Options.

  10. To ensure that newer versions of the Intelligent Cube overwrite previous versions of itself in the History List, select the The new scheduled report will overwrite versions of itself check box .

  11. To specify an expiration date for the subscription, select the Do not deliver after check box and choose a date from the calendar.

  12. If you want to have a delivery notification email sent to all recipients when the delivery is sent, perform the following steps:

    1. Select the Send notification to each recipient's email address check box.

    2. Type the email address in the New address field.

    3. From the drop-down list, select the type of email address you want to send the email to, such as Generic email or Microsoft Outlook.

  13. Click OK. The subscription is created.

To verify that you are subscribed to the report or document, click the MicroStrategy icon Projects icon at the top of the page and select My Subscriptions. The subscription appears in the History List Subscriptions section.

Related topics