Page History

Building process of data sets is triggered by the data or structure change in the underlying data sets (when automatic rebuild is enabled) or manually by user. During the building process, all referenced data sets are locked for performing changes. Changing joins structure (add join point, remove join point, change type, remove all) will cause, that the join is flagged as needed to be rebuild, but the rebuild itself is not scheduled.

Disabling the building process

Disable process for particular data set

There are situations, when we don't want to start the building process automatically, especially in the "big" data sets. It is possible to disable automatic rebuild in the settings of the joined data set:

Disable process for all data sets in specific time interval

In specific cases, for example if there are many joined data sets build on several daily updated data sets, each change of the underlying data set triggers the building process. It may cause "locking" errors when the system will try to import data into another referenced data set which is part of the join. For this situations, you can disable the building process for the specific time interval:

Rebuild delay and Custom Rebuild time

In some cases, it might an efficient solution to define a rebuild delay or set up a custom rebuild time. They are useful in situation when there are two or more imports to the underlying data sets scheduled to almost identical time. Without the delay, first import will trigger the rebuild. This will lock the data sets which will cause failure of the rest of the imports. By setting up a delay or a custom rebuild time, the rebuild won't be mediately triggered and all the imports will be successfully finished. By using custom rebuild time, it is possible to schedule the rebuild to a time when the load of the server is the smallest.

It is possible to set them up in the settings of the joined data set: