Hi There,
I have an interesting challenge that I think I'll have to write customized coding for. Thought I'd post it on this forum to get some statistics and expert ideas...
I have a data set of monthly volumes of a product by province, region, & then city.
I use Forecast Studio to create projects and use the rules of hierarchal forecasting in the tool for a bottom up reconcilation.
The timeseries trends show growth, however I still enter in an provincial override to almost 100% inflate that growth for the longterm forecast. FS disaggregates the overide by proportions of the reconciled forecast. My challenge here is I'd like to decrease those proportions and distribute out the disaggregations for the long term overrides more evenly.
For example if one product has 10% of the distributed override, then for next override, I'd like that allocate only 8% of the override, and then next month 5% etc etc. Since the granular timeseries trends are increasing, the way FS is disaggregating the override does not reflect this scenario.
Is there a way to code this situation or control/change the distribution of how the override is allocated in FS (other then the two options of: based off of proportions or evenly distributed) ?
Thank you kindly!
