Skip to Content
0
Apr 11, 2014 at 09:32 AM

Forecast not disaggregating properly

43 Views

Hi,

We calculate forecast on monthly level and disaggregating it to week level.

We follow Calendar year 4, 4 and 5 Weeks.

Year 2015 has 53 Weeks so in DEC 2015 we have 6 weeks. ( As per our design).

1. When our Monthly-Forecast Process Chain ran, for month "DEC 2015", forecast got disaggregated into 1st 4 weeks and the last 2 weeks were populated with "0".

Example:

Monthly Dec-15 Monthly 6000 Weekly 1500 1500 1500 1500 0 0

2. Checked in Dev: when values entered in Development for DEC 2015 it is properly getting disaggregating into 6 weeks. It reflects that the disaggregation Macro is working correctly.

Example:

Monthly Dec-15 Monthly 6000 Weekly 1000 1000 1000 1000 1000 1000

3. Secondly: When I ran the macro manually in Production for DEC 2015 and re-disaggregated the forecast it gets populated correctly to all weeks.

But in the next run of our Monthly-Forecast Process chain the "0"s were shifted to last 2 weeks of next month i.e. JAN 2016.

Example:

Monthly Dec-15 Jan-16 Monthly 6000 5000 Weekly 1000 1000 1000 1000 1000 1000 2500 2500 0 0

Regards

Lalit