Forecast not disaggregating properly

[lalit_behere]

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

[former_member182607]

Lalit,

I need more details...are you using fiscal periods? How are you doing the time based disaggregation?

Thanks,

Subash

[lalit_behere]

Hi Subash,

Yes we are using Fiscal Periods. As  I stated we follow a 4, 4, 5 weeks pattern in a year.

For Time based disaggregation we are using another key figure which is again based on another key figure for Time based disaggregation and for this we are calculating the proportions on the basis of Demand History Override ( manual entry)

Key Figure	Calculation type	Disag, KF	Time Based Disag.	Time Based Disag. KF
STAT	P	PROPFNL	K	TIMEFNL
TIMEFNL	S		K	PROPFNL
PROPFNL	P	APODPDANT

Regards