Forecast function in obiee, how to use?

Question

I was trying to use forecast function in Obiee 12c. I used it in one analysis it worked, but when I used it in another with other measure it displays straight line, however the measure itself is fluctuating.

I couldn't get why the same function that worked in one case won't work in similar one.

Here is how I used it:

FORECAST("KPI Результаты Сотрудника"."Indicator", ("Time"."YEAR","Time"."QUARTER","Time"."MONTH"), 'high', 'modelType=arima;numPeriods=%1;predictionInterval=%2', 6, 90)

Below is the resulting graph

Did someone tried it? How can we get more realistic forecast?

Edit 1. Here is my data in tabular format. Here I selected one employee and its KPI for last 6 months, I want to forecast for the next 6 months

Year    Quarter    Month   Indicator    High    Low    Forecast
2016    1             01    70           
                      02    47           
                      03    45           
        2             04    73           
                      05    47           
                      06    43           
        3             07                  74    34      54
                      08                  74    34      54
                      09                  74    34      54
        4             10                  74    34      54
                      11                  74    34      54
                      12                  74    34      54

Answer 1

Yes i have worked on oracle obiee and i know what is the issue, looks like your data does not contain seasonality and trend components, if these component are absent then forecast will be simple average of previous value and you will get straight line, it will be helpful if you upload your input dataset.