Data Load - Data Model Series Accumulation Is Not Working Properly (Doc ID 1417579.1)

Last updated on JULY 01, 2016

Applies to:

Oracle Demantra Advanced Forecasting and Demand Modeling - Version 7.3.1 and later
Information in this document applies to any platform.

Goal

On VERSION 7.3.1 48
The series sdata15 was changed through Business Modeler in order to obtain a Summary loading data for a week, and not an average. Still data loaded appears to be averaged:

The loading data in sdata15 column of t_src_sales_tmpl table. This sdata15 series is proportional

Steps performed:
1. It was prepared the following data set loading for - sales_date sdata15
       04-JAN-12   10
       05-JAN-12     0
       06-JAN-12   10
2. Run ep_load_sales
3. Check the loaded value
       01-JAN-12 6.6666666667
  Its a Sunday weekly system, it should be 20 not 6.66.

Checked computed_fields, but all fields are already summary.
If we set in DataModel the sum and just save, then it will work as expected?
Is it mandatory to upgrade model, or just save it in order to have this behavior?

Solution

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