Schedule measures

You can refresh measures on the scheduled system refresh, weekly, monthly, or manually on demand. To help your most needed measures refresh faster, schedule last season's measures or measures that don't change often on a slower cadence such as monthly. The default is every scheduled system refresh.

Prerequisites for automatic refresh of a measure

• A system refresh must be scheduled. Daily system refresh is recommended.
• The custom schedule for a measure must align with the system refresh schedule.

  Caution

  If someone changes the system refresh date after you set custom schedules for your measures so that the dates no longer align, your measures don't refresh as scheduled until their custom schedules align with the new system refresh schedule. Change your measures custom schedules to align with the new system refresh schedule or refresh the measures manually.

Create custom refresh schedules for measures

Define refresh schedules for one or more measures. The Schedule column of the measure list shows the currently defined schedule.

1. Go to Insights > Measures.

2. Select the measures you want to schedule.

3. Select Schedule.

4. In the Schedule pane, set the Schedule run to On to run the measure automatically. Set it to Off to refresh it manually.

5. For automatically refreshed measures, select Recurrence and the details for it.

6. When defining the schedule for several measures, make a selection under Keep or override schedules:

   • Keep individual schedules: Keep the previously defined schedule for the selected measures.
   • Define new schedule for all selected measures: Override the existing schedules of the selected measures.

   

7. Select Save and then confirm the change. The system refreshes the measures on the scheduled date.