Scheduler

The Scheduler allows you to plan when and how often a cube is refreshed or reloaded. By creating scheduled jobs, you can automate cube data updates to ensure users always have the latest information without manual intervention. Scheduling also helps balance system performance by running heavy cube loads during off-peak hours.

You can refresh jobs screen at any time by clicking Refresh Screen Data in the Options panel.

When to schedule a job

• Updating at regular intervals: Keep cube data current without manual intervention.
• Automating data availability: Ensure cubes refresh before critical reporting times so data is ready for analysis.
• Reducing system load: Run large loads or refreshes during off‑peak hours to optimize performance.

Job column

Column	Description
Description	Name of the scheduled job.
Action	Process performed for the job: Load All or Refresh.
Type	Frequency of the job.
Active	Status showing whether the job is active.
Last Start Run Date	Date and time when the job last started.
Last End Run Date	Date and time when the job last finished.
Next Run Date	Date and time when the job will next run.
Status	Result status of the last job execution.

Schedule a job

1. On the Administration page, select OLAP Manager from the sidebar.
2. Select the cube you want to schedule a job.
3. In the Options panel on the right, click the Navigation icon.
4. Select Scheduler.
5. In the Options panel, click the Add Job icon.
6. Enter the required job properties and time settings in the Job Details dialog.
7. (Optional) Adjust the time zone or set an expiration date if needed.
8. Click Save.

Job Details

Properties

Property	Description
Description	Name for identifying the job.
Action	Process assigned to the job. Load All – Removes all cube data and reloads everything from the source. Refresh – Adds only new records according to the tracking method defined at the Data Source level.
Environments	Environment used for the job execution.
Active	Status showing whether the job is active.

note

If the cube is new or if the previous job did not complete successfully, the next job will always perform a Load All action, even if Refresh was selected.

Settings

Set the job frequency using these options:

Property	Description
Once	Delivers the visualization once based on your settings. Start On – Choose the specific date for delivery. At / From – Choose a fixed time (At) or a time range (From…until) with defined delivery intervals (in minutes).
Daily	Delivers the visualization on a daily basis based on your settings. Start On – Choose the specific date for delivery. At / From – Choose a fixed time (At) or a time range (From…until) with defined delivery intervals (in minutes). Recur every X days – Set the number of days (1–31) between deliveries, for example, every 20th day.
Weekly	Delivers the visualization on a weekly basis based on your settings. Start On – Choose the specific date for delivery. At / From – Choose a fixed time (At) or a time range (From…until) with defined delivery intervals (in minutes). Days – Select one or more specific days of the week
Monthly	Delivers the visualization on a monthly basis based on your settings. Start On – Choose the specific date for delivery. At / From – Choose a fixed time (At) or a time range (From…until) with defined delivery intervals (in minutes). Months – Select specific months for delivery. Days / On – Choose a specific day of the month for delivery or enable the Everyday toggle for daily delivery. Alternatively, you can use the On option to specify the First, Second, Third, Fourth, or Last occurrence of a particular weekday. Multiple occurrences can be selected.

Time Zone

Select the time zone in which the job should be executed.

Advanced Settings

For the Daily, Weekly, and Monthly options, you can set an expiration date and time to stop receiving visualizations from this subscription.

Manage a scheduled job

Edit a job

1. In the job list, select the job you to edit.
2. In the Job Details dialog, make your changes.
3. Click Save.

Stop a job

1. In the job list, select the job you to stop.
2. In the Options panel on the right, click the Actions icon.
3. Select Stop Job.

Delete a job

1. In the job list, select the job you to delete.
2. In the Options panel on the right, click the Actions icon.
3. Select Delete Job.