RDF: Forecast Approval Workbook Arrays Are Expanding to Enormous Sizes
Last updated on OCTOBER 28, 2016
Applies to:Oracle Retail Demand Forecasting - Version 184.108.40.206 and later
Oracle Retail Predictive Application Server - Version 220.127.116.11 and later
Information in this document applies to any platform.
Forecast Approval workbooks, despite being small with 200 SKUs x 200 stores and only 104 weeks, are blowing up to enormous sizes. This is causing performance issues as well as disk infrastructure issues. Larger workbooks (e.g., 1000 SKUs x 200 stores x 104 weeks) albeit still small in reality, are blowing up to 20-30GBs.
This is due to the _t arrays that RPAS uses to track changes. Those arrays are blowing up due to the change we have made to the calcmask procedure that calculates the cmtmsk##xb measure, which in turn calculates the 'approved forecast' measures. The _t arrays for approval measures are getting marked as "every cell has changed, including historically" when the approval is performed.
Example array sizes from a production environment are as follows:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms