Splicer

The inspiration to create Splicer came from a performance review of the Apliqo FPM model rules. We discovered that specific rule structures can significantly hinder performance, such as the IF - CONTINUE statements. In many cases, these rules could be efficiently replaced by embedding target elements directly in the rule's area statement, resulting in a considerable performance boost. However, embedding these elements manually can be challenging as most of these fixed values depend on the FPM model configuration, which varies from one customer to another. Moreover, any changes to the model configuration, like the current fiscal month or currencies, would necessitate manual updates to most of the model rules. To mitigate the need for manual rule editing, we introduced Splicer.

Splicer has a straightforward role - to conduct a smart search-and-replace function within the area statements of rules. It identifies segments of the area statement where element replacement is needed and queries the Apliqo FPM model for a list of elements that match particular settings. The outdated elements are then substituted with the newly found ones and the rule is then saved. Saving a rule might recalculate feeders – that will come as a cost of flexibility Splicer offers.

 Additionally, Splicer is able to generate KPI rules according to definition in FPM Chart of Accounts model.