MicroStrategy ONE

Incremental Refresh Schedule for the Platform Analytics Cube

By default, the Platform Analytics cube is scheduled to complete a full republish every hour on the 30th minute. For customers with very large datasets, this full republish could take a significant amount of time as it loads every row of every table/view into the in-memory cube. Incremental refresh subscriptions consist of smaller data fetches from non-static tables that are appended to the already existing cube cache loaded in memory. Executing faster than a full republish, incremental refresh schedules allow updates to the Platform Analytics cube much more often so the data stays fresh and relevant.

It is recommended when adopting incremental refresh subscriptions, to change the default republish schedule to occur less frequently. For example, a full cube refresh can be performed once a day with an incremental refresh every 15 minutes. This can be adjusted based on the performance of your cube publication and incremental refresh.

Creating the Incremental Refresh subscription requires access to MicroStrategy Developer and MicroStrategy Web.

Creating the Incremental Refresh Schedule

  1. Open MicroStrategy Developer and log in to your project source.
  2. Expand Administration > Configuration Managers > Schedules.

  3. Right click in the list of schedules and select New > Schedule.

  4. Change the name to something descriptive and click Next.

    PlatformAnalytics_Every15Min_IR will be used for this example.

  5. Select Time-triggered and click Next.
  6. Select No end date and click Next.
  7. Set the Recurrence Pattern to Daily / Every 1 Day.
  8. Set the Time to trigger to Execute All Day Every / Executing every: 15 minutes.
  9. Click Next then Finish.

Apply the Schedule to the Platform Analytics Project

  1. Log in to MicroStrategy Web and open the Platform Analytics project.
  2. Browse to Shared Reports > 2. Utilities.
  3. Right-click the Platform Analytics Cube and select Schedule.
  4. Click Show Advanced Options.

  5. For each table listed:

    • Check the box next to the table name in the Data Source column
    • Change the Refresh Policy to Update Existing Data and Add New Data.
    • Click Set Source.
    • Click on the DSN for the Platform Analytics Warehouse.
    • Choose the namespace for the Platform Analytics Warehouse. The default is platform_analytics_wh.
    • Begin typing the view name into the Table text box.

    • Double click the incremental view corresponding to the selected table and click Finish.

      Table Name Incremental View

      fact_access_transactions_view

      		fact_access_transactions_incremental

      fact_action_cube_cache_view

      fact_action_cube_cache_incremental

      fact_action_security_filter_view

      fact_action_security_filter_incremental

      fact_latest_cube_cache

      fact_latest_cube_cache_incremental

      fact_object_component

      fact_object_component_incremental

      lu_account

      lu_account_incremental

      lu_cache

      lu_cache_incremental

      lu_cache_object

      lu_cache_object_incremental

      lu_component_object

      lu_component_object_incremental

      lu_history_list_message_view

      lu_history_list_message_incremental

      lu_object

      lu_object_incremental

      lu_project_object

      lu_project_object_incremental

      lu_session_view

      lu_session_incremental

      lu_status

      lu_status_incremental

      lu_subscription

      lu_subscription_incremental

      lu_validating_account

      lu_validating_account_incremental
  6. Change the Schedule drop-down to the schedule created in the previous section, PlatformAnalytics_Every15Min_IR.

  7. Set the Schedule name field to something descriptive, such as Platform Analytics Cube PlatformAnalytics_Every15Min_IR.

  8. Click Schedule, then Done.

The Platform Analytics Cube will now be incrementally refreshed with the latest data every 15 minutes rather than one hour.