Previous
Previous
 
Next
Next

Forecasting Programs

The OLAP DML has several related statements that allow you to forecast data using the Geneva Forecasting engine which is a statistical forecasting engine from Roadmap Technologies that is used extensively in demand planning applications.

To forecast using the Geneva Forecasting engine, take the following steps:

  1. Add the future time values to the time dimension.

  2. Create a variable to hold the results of the forecast.

  3. Write a forecasting program. Within the program, issue the following statements in the order indicated:

    1. FCOPEN function -- Creates a forecasting context.

    2. FCSET command -- Specifies the forecast characteristics.

    3. FCEXEC command -- Executes a forecast and populates Oracle OLAP variables with forecasting data.

    4. FCQUERY function -- Retrieves information about the characteristics of a forecast or a trial of a forecast.

    5. FCCLOSE command -- Closes a forecasting context.

For examples of using these statements to forecast data see Example: A Forecasting Program.