topic Re: Reconciliation with SAS forecast studio in Statistical Procedures

Reconciliation with SAS forecast studio

ghes1 — Wed, 04 Aug 2021 20:24:09 GMT

Hello,

I am developing hierarchy forecast in SAS forecast studio to predict pickup volume. There is an issue with average reconciliation method. Based on historical data there are no days with zero volume, and SAS has a volume forecast for every days, but after reconciliation (Average method) it produce zero volume for some days.

Is there any way that I can resolve the issue and prevent the zero volume forecast?

Thanks!

Re: Reconciliation with SAS forecast studio

gcjfernandez — Wed, 04 Aug 2021 23:28:44 GMT

Please check: ignore zero forecasting during reconciliation is checked

Re: Reconciliation with SAS forecast studio

ghes1 — Thu, 05 Aug 2021 13:49:01 GMT

Thanks for the response. I checked the "ignore zero forecasting during reconciliation" and ran the project but still get the zero volume.

Re: Reconciliation with SAS forecast studio

gcjfernandez — Thu, 05 Aug 2021 23:34:00 GMT

Please post the Forecast summary report:

Re: Reconciliation with SAS forecast studio

ghes1 — Fri, 06 Aug 2021 13:04:14 GMT

Re: Reconciliation with SAS forecast studio

gcjfernandez — Fri, 06 Aug 2021 23:18:03 GMT

Based on the forecast summary chart more than 20% of the series are IDM. Please exclude these series and try again. By the way what reconciliation method you are using?

Re: Reconciliation with SAS forecast studio

ghes1 — Mon, 09 Aug 2021 12:09:52 GMT

Sure, I'll do that. I am using Top-down reconciliation.