Caching Lookup Results

The calculation logic contains multiple lookups from both raw user data (like Datamarts, Data Sources or Product Extensions tables) and calculation specific configuration in Price Parameters. Most lookups are cached by default (e.g. sales and forecast data or configuration from Price Parameters), but lookups based on product segmentation are not.

It depends on the granularity of the product segmentation and the number of products whether caching such a configuration helps the logic execution times.

To address this, you can use the Cache lookup results option in the Set Parameters step:

Open

By default it is switched off since it may impact the performance negatively (particularly in cases where the segmentation is more granular). This should be the first thing to check when seeking performance improvement.

In price list logics, in the “Config Lookups“ element you can see multiple lookups of the same information with different features.

Open