Schedule "Changes only" EC build

[vaibhav_j]

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 "Replace All" build at the scheduled time. I wish to run a "Changes only" build at the scheduled time. Any insights? Thanks!

https://documentation.sisense.com/w2022-3-x/docs/scheduling-builds

[HamzaJ · Accepted solution]

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.

[HamzaJ · Accepted solution]

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 · Accepted solution]

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.

[vaibhav_j]

Thank you @HamzaJ and @irismaessen for your quick responses. Appreciate it!