How to Schedule a Cube Refresh

You can schedule an Intelligent Cube refresh. It allows documents and reports subscribed to it to be run as quickly as possible using the latest available data, without having to query the data warehouse.

Cube update subscriptions execute a cube against the data warehouse. This retrieves the most recent information for the cube and then publishes it. The subscription does not update the caches for reports that use the cube.

You must have the Administer cubes privilege to schedule a cube refresh.

To Schedule a Cube Refresh

1. Navigate to the Intelligent Cube you want to refresh.

2. Right-click the cube, and select Schedule.

   

3. Select the data sources to be refreshed.
4. Select the refresh policy. This determines the approach to existing data at refresh.
5. To set refresh filters, or alternate data sources, select Show Advanced Options.
6. Select an existing schedule or create a custom one.
7. Enter a name for your new schedule into the Schedule Name field.
8. Select the Schedule button.
9. Click OK.

To verify that you are subscribed to the cube refresh, at the top of the page, click the MicroStrategy icon , then select My Subscriptions. A list of your subscriptions appears.

When you import a CSV file, you can set various parse data rules like the number of rows to skip, delimiter, and quotation marks type. When you republish a cube, and upload other data from disk, or the content changes in the source, MicroStrategy will not auto-detect parse rules. It will instead inherit previously set rules.