Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Can I forecast future years for accounting data?

Accepted answer
122
Views
7
Comments

OAS 7.0


I am attempting to make a forecast for future accounting data based on previous years og transaction. At this point it is essentially the attributes "Year" and "Amount". I have data from 2016 onward and would like to create a forecast for 2024, 2025 and so on.

My problem is that I don't really understand how to make to make the forecast appear in the workbook. I am using a linechart, applying the forecast and then I cannot really see the forecast, although the statistics option to apply forecast does appear greyed out.


Is it something I do not understand here? Is this intended use, or not really? My user story is that I want to use historical accounting data to make an indication of budgets for the next 4 years, ideally broken down by some more attributes like department.


Thanks in advance!

Welcome!

It looks like you're new here. Sign in or register to get started.

Best Answer

  • Hi Kristian,

    It all depends on your data types.

    Here's Amounts by Year and the Year is of data type "Text":

    Here's Amounts by Year and the Year is of data type "Number":

    Here's Amounts by Year and the Year is of data type "Date":

    And bingo...here's your forecast :)

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.