Aggregation in formulas
In Incentives, you can significantly enhance performance by properly structuring your calculations.
Recommendations
Always aggregate calculations: When constructing calculations, always include aggregations. Methods such as SUM, MIN, MAX, and AVG not only streamline the calculations but also ensure optimal performance.
Special considerations for AWS and PPO models: Check older models for unaggregated calculations and update them to include aggregation.
In AWS and PPO models, the need for aggregations becomes even more critical. Unaggregated calculations hinder the use of Spark processing power and limit parallel execution to only two calculations. Therefore, all calculations must be aggregated unless they specifically employ the PREV function. Note that the latest release enforces this rule, preventing unaggregated calculations in new models; however, older models might need manual updates to adhere to these best practices.
Identifying non-compliant calculations
Calculations that do not follow aggregation best practices can be identified through the following steps in the Admin Client:
From the admin panel, click Model settings
→ More options.Click the Calculation tab.
 |