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 Data Refresh.

3. Expand the Schedule drop-down list and choose a schedule template.

4. Type a Schedule Name.

5. Optionally select the check box next to the data sources you want to refresh.

6. Choose a Model Refresh Policy or Refresh Policy from the following options:

   If a data source Refresh Policy value differs from the default Model Refresh Policy value, the Refresh Policy value will take precedence.

   • Replace existing data: Overwrites existing data.

   • Add new data: Retains existing data without modifying it, and adds new data not previously included.

   • Update existing data: Updates your existing data.

   • Update existing data and add new data: Updates your existing data and adds new data not previously included.

7. Optionally define a refresh filter:

   1. Select Refresh Filter next to a Data Source.

   2. In the Based on drop-down list, choose an option and define the filter depending on your selection.

   3. Click Save.

   4. To add more filters for the data source, click Add New and define your new filter.

   5. Click Save. Refresh Filter indicates that there is a refresh filter set on the schedule.

      Click here to see filter statuses.

      • Not Set: The refresh filter is not dependent on the table.

      • Set: The refresh filter is dependent on the table.

      • N/A: The table does not support refresh filters. The table may not be supported if the source is a local file or the table has saved wrangle operations.

8. To refresh your data source immediately, select the check box next to Refresh data now.

9. Click Save.