Hi everyone, Sorry for this long post. I really need your Forecast Studio expertise help. I am pretty new to FS so there are many things I am not so sure. I need to create a demand forecast model for weekdays (Mon-Fri). My dataset has the following characteristics: - Demand is usually higher at the beginning of the month. For example: If Feb 1 is on Wednesday, the demand on Feb 1 will be higher than demand on other Wednesdays - Demand is usually higher at the beginning of the week. \ For example: Monday demand is higher than other weekdays - There is no demand on Public holiday. Demand on the day right after public holiday will higher than normal For example: Public holiday is on Mon. Demand on Tuesday right after PH will be higher than other Tuesdays Questions: 1/ How can I set 2 seasonal cycle length (5 days weekday and 20 days monthly) for a forecast? 2/ Can I set an event to indicate certain percentage increase at the beginning of the month? The current event repository is designed in a way that I need to add specific date to event table e.g. 02Jan2014, 01Feb2014, 01Mar2014,... Plus, I can only indicate there is an increase yet I cant decide percentage or absolute increase. The increase is decided by the FS automatically. 3/ Currently I use 20 as seasonal cycle length and I have an uplift table outside FS. The table will indicate % uplift and absolute increase. Forecast result from FS will be uplifted in the db itself, not in FS. I have a problem with this design. Let's say I want to forecast demand from 01Feb2014 to 10Feb2014. If Monday,01Feb2014, is public holiday, my forecast model still forecast demand for Monday (it is not supposed to forecast for Monday because demand is 0). On the next day (Tuesday,02Feb2014), actual demand will be higher than other Tuesday but my forecast model doesnt know Tuesday is the day after PH so it will forecast a demand similar to other Tuesday. I will uplift the forecast figure in database, outside FS so that will not be reflected in my model. Assume that my model forecast 400 for Tuesday, 02Feb2014 but the actual demand is 600. Next day, when I want to forecast demand from 03Feb2014 to 12Feb2014, actual demand for 02Feb2014 is now part of my historical data for this forecasting. Since previous forecast for 02Feb2014 is 400 and actual is 600, when doing forecast from 03Feb2014, the model will think that it under-forecast last time so it will assume pattern repeated with higher increasing trend. Therefore, the model will auto-adjust itself and as a result, it will over-forecast demand from 02Feb2014 to 11Feb2014. How can I tell my FS that the increase on 2Feb2014 (after PH) is temporary, dont take into consideration this temp increase? 4/ I am trying to resolve problem described in 3/. I believe if the forecast for 2Feb2014 is close to actual demand, FS will not over forecast for demand from 03Feb2014 to 12Feb2014. Therefore, I am trying to bring the uplift to inside FS instead of outside. I am not sure if override method will work in this case. Override calculator will allow to override forecast with certain percentage increase of statistical forecast. When I unarchive the FS project, I am able to see override figures are stored in outovrd.sas7bdat dataset. I plan to use override logic to indicate % uplift for dates I want and use sas code to store override figures in outovrd.sas7bdat dataset. The final forecast result after uplift/override will be stored in finalfor.sas7bdat. I believe after uplift/override forecast is closer to actual forecast for 2Feb2014 so next time when I run model to forecast from 3Feb2014 to 12Feb2014, my model wont see a significant different between its forecast and actual thus it wont over-forecast. I am not sure if my line of thought is correct. Even when it is correct, I cant figure out where the code to calculate override figures is in model project folder. In fact all of my above questions are to figure out a solution for problem described in 3/ . Really appreciate sas communities help. Regards, Hien
... View more
