Impact of imports on calculations
When designing imports, it is important to understand that the frequency at which they run and the data changes they cause could have a significant impact on the overall calculation run time. Clients should be aware of situations that could lead to longer-than-expected calculation times, such as extensive data changes in multiple open periods or significant historical data loads.
In most cases, you can reduce the total number of calculations by using the incremental calculation feature, which allows only calculations requiring updates to run.
Trigger mechanism
Incentives marks a calculation to run when its source data changes, such as when a transaction table receives new records from a recently executed import.
Note
The benefit of incremental calculation may be negated if all calculations are marked to run due to data changes in all data, custom, and structural tables.
Recommendations for designing imports
When designing imports, consider the frequency at which they run and the data changes they cause, as this can significantly impact the overall calculation run time.
Instead of running imports frequently just because Varicent allows it, understand how the data can change daily and configure imports to run the minimum number of times necessary to meet business requirements.
Impact of calendar periods on calculation time
Data changes in open periods
If data changes occur in an open period that spans many previous periods, calculations requiring this data may have longer run times due to the need to refresh more open periods.
Historical data loads and refreshes
Expect similar delays when there is a large load of historical data or when data has been cleared and refreshed.