Forum Discussion

vaibhav_j's avatar
vaibhav_j
Cloud Apps
07-28-2022
Solved

Schedule "Changes only" EC build

Hello, Is there a way to schedule a "Changes only" build in Sisense? As per the article below, it appears that there is no option to select what type of build I want to run. By default it runs a "R...
Technology
  • HamzaJ's avatar
    HamzaJ
    07-28-2022

    Hi vaibhav_j 

    If I am not mistaken , it takes the last build option. So if you build the EC with changes only. The scheduled build will also build Changes Only. 

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

    If this way is not prefered, you could also use the windows Taskplanner to execute EC-refreshes. You can then set what type of build should be done.

  • irismaessen's avatar
    irismaessen
    07-28-2022

    A 'Changes Only' build only builds tables/columns that have been changed within the elasticube structure. Are you sure that's what you want?

    If you want to update tables with new data without deleting old data, you can define an 'accumulate by' field in these tables and then perform a 'by table' build. 

    It does appear that the last type of build that was manually started will be used for any scheduled builds, like HamzaJ also says. We use a script using the REST API to do our own scheduling, to be called by the Windows Task  Scheduler or a Linux cron job. This lets me set a schedule for all our cubes and even set time ranges when a full or a by table build should happen.

irismaessen's avatar
irismaessen
Data Pipeline
07-28-2022

A 'Changes Only' build only builds tables/columns that have been changed within the elasticube structure. Are you sure that's what you want?

If you want to update tables with new data without deleting old data, you can define an 'accumulate by' field in these tables and then perform a 'by table' build. 

It does appear that the last type of build that was manually started will be used for any scheduled builds, like HamzaJ also says. We use a script using the REST API to do our own scheduling, to be called by the Windows Task  Scheduler or a Linux cron job. This lets me set a schedule for all our cubes and even set time ranges when a full or a by table build should happen.