Scheduling Data Loads

Applicable to Sisense on Linux and Microsoft Windows

After you build an ElastiCube, you can schedule future builds to automatically synchronize with the underlying data source to ensure all data is up to date.

There are two options you can choose when scheduling a build: by time or by intervals. Builds scheduled by time occur according to the days and hour you define. You can configure Sisense to build an ElastiCube automatically any or every day of the week at the same hour.

Builds scheduled by intervals occur after the defined interval passes. You can set a single interval for an ElastiCube.

Note: Only one option can be selected at a time. The last configuration you set is the configuration that will be used.

If you want to cancel a scheduled build, select Disable and click Save.

By default, scheduled builds are Full builds (replace data in all tables with the current data from the source), unless any table within the ElastiCube is set to Accumulative or a table is set to be ignored.

Your ElastiCube’s build configuration determines how the scheduled build is to be performed. For more information about how to build ElastiCubes, click Building ElastiCubes.

To schedule a build:

  1. In the Data page, open the menu of the relevant ElastiCube and select Schedule Build. The Schedule Build window is displayed.

  2. Select the relevant scheduling option:
    Disable: Click to disable a scheduled build.
    Daily: Select the relevant days and define the hour when the build is to occur. For each selected day, the build will occur at the same hour defined. Note: The build will occur according to the timezone of the Sisense server, and not according to the timezone of your machine.
    Interval: Select the time in between automatic builds. The first automatic build begins after you save your settings and the interval passes.
  3. Click Save.