Skip to main content

CPM

Loading

The load settings on the datamodel allow you to set all detailed options on the Celonis Engine loads.

34440551.png

1. The cache retention defines how long the results are kept in hot-cache when they are not used.

2. The cache eviction defines thresholds when to start and stop removing entries from the hot-cache.

34440552.png

3. Enabling Query Caching will cache queries running longer than one second. Size and warm up time can be configured. With CPM 4.7, query caching is enabled by default with 150MB cache size and 15 minutes max. cache warm up time.

4. Load scheduling allows you to define continuous engine reloads. You can choose pre-set time intervals for the reloads, create a custom CRON job or trigger the reload from a database table.

5.Partial load scheduling allows you to define continuous partial reloads of specified tables.

34440553.png

6. Distributed calculation specifies which Compute Server the data model should be loaded on in case of a Mulit-Server-Deployment.

7. The Log level specifies the granularity of the Compute Logs.

34440554.png

8. Settings to limit the CLUSTER_VARIANTS and ESTIMATE_CLUSTER_PARAMS operators.

9. Load column allows you to exclude columns in the data tables. Those columns will not be loaded to the Celonis Engine. This can significantly reduce load times.