Forecast (Workbook and Data flow)

Question

I have sales data with product, date, and quantity sold. I would like to generate a time series forecast for each product and export the results into a CSV file. When I create a forecast in a workbook, I can only generate a line chart, but I’m not able to convert the forecast into a table or export it. When I try using a data flow, I can get the forecast in table form, but I haven’t been able to generate the forecast per product. Is there a way to produce and export forecasts per product into CSV in Oracle Analytics Cloud?

Benjamin Arnulf-Oracle · Accepted Answer

Hi Julianne, I think it would be a brilliant idea to allow users to export or see in a table format the forecast created on a graph using ETS, Arima or Prophet. I would recommend you to add this idea to our lab. I will vote for it.

Idea Lab:

https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server

+ @Philippe Lions-Oracle

Gianni Ceresa · Accepted Answer

Hi @Julianne ,

Did you try using the forecast function as in expression?

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/functions.html

I just added a table visualization in a workbook, added product, date, revenue and quantity and then added 2 calculations with a forecast for revenue and quantity. As you can see the forecast is at the product level, each product has its own forecast.

Benjamin Arnulf-Oracle · Accepted Answer

Thank you @Gianni Ceresa I learnt something! I tried with the ETS modelType and it's working perfectly. I was also able to create a calculation to put the forecast and the sales on the same column using CASE IF.