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 02. 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 10003. 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 0Regards
Lalit