i'd like to know whether it is possible to debug the forecast function, included in Oracle 12c as forecast seems to be incorrect, if the forecast is based on just a few Input values (e.g. < 10 time values ).
Is there a possibility to get forecast working for time intervals with less than 10 time periods (years, months etc.)?
I built an simple test answer, trying to forecast business revenues for 3 years ahead, based on the last 5 business years.
Forecast results seemed fine, when the forecast was based on a lot of input values (e.g. more than ten years). But when there were less input values (e.g. less than 10 years), then forecast-values stayed the same for every year.
OBIEE 12c Version used: 18.104.22.168.0 (on premise)
Simple test answer:
The answer includes 3 columns: Time.Year, Facts.Revenue, Forecast
My column formular for the forecast column looks like this: