18 Month rolling forecast in webforms
We are using Planning v11.1.1.3. We are planning to have 18 month rolling forecast. For this requirement, the web-form will have 18months of forecast to start with and as we move ahead in the year, the form will have Actuals plus 18 months of forecast. (e.g. if Oct 2009 is current month, form should have Actuals: Jan09-Sep09 and Forecast: Oct2009 to Mar2011).
One way to do is create lots and lots of substitution variables. Please provide your thoughts on how to implement this in webforms. Also, let me know if the substitution variables method can be used in a better way.
Please advsie. Any guidance will be very useful.
Thanks in advance.
DV