Forecast ML feature in OAC

Rameez Shaik-Oracle

Summary:

Regarding Forecast section, an option to select the Model as 'Seasonal ARIMA'/'ARIMA'.

Content (required):

Hi Team, In the Forecast section, there is an option to select the Model as 'Seasonal ARIMA'/'ARIMA'. Any idea what are the hyper parameters that are passed from the OAC platform end to forecast the future data?

Also, is it possible to pass hyper-parameters during run time by the user running the report?

Version (include the version you are using, if applicable):

6.1

Code Snippet (add any code snippets that support your topic, if applicable):

image.png

EloiLopes-Oracle

Hi,

You can add forecasts using right click and add statistics, and for that forecast you can only change periods or the algorithm.

But, you can add forecast using a calculation column adding the forecast function where you can specify more parameters.

Example:

FORECAST(

revenue, 

(time_year, time_quarter), 

'forecast', 

'modelType=arima;numPeriods=6;predictionInterval=70;'

)

Please check documentation to find all details about each parameter.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/functions.html#GUID-85E0FDF7-BF01-49CB-BAE0-55A19BA33737

https://blogs.oracle.com/analytics/post/how-to-add-functions-with-a-simple-right-click-in-oracle-analytics

Regards,

Elói