Performance Is Slow when Running Multiplication Calc Rule in Profile Spreading
(Doc ID 3038610.1)
Last updated on AUGUST 12, 2024
Applies to:
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 24.0 and laterOracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 24.1 and later
Oracle Retail AI Foundation Cloud Service - Version 23.2 and later
Information in this document applies to any platform.
Goal
Batch calculation group performance is slow when the rule includes a multiplication in profile spreading. The rule is C=A*B. This simple operation is currently taking around 3 hours. The left-hand side (LHS) is at sku/stor/week and both right-hand sides (RHS) are at aggregated level, one of them is at sku/stor level thus logically it needs to be replicated across week.
Steps to troubleshoot would be to isolate the rule that is taking most of the performance time. Set the RPAS_LOG_LEVEL to debug or all and rerun the batch calc group and carefully review the logs.
For this particular example, the ratio is already calculated with a mask, not every sku/stor is populated and the week is ranged by B. However, for reference, consider if there was not already a mask being used, then use a mask to reduce the scope of calculation, for example: C=if (mask, A*B, 0).
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |