![]() Previous |
![]() Next |
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:
Add the future time values to the time dimension.
Create a variable to hold the results of the forecast.
Write a forecasting program. Within the program, issue the following statements in the order indicated:
FCOPEN function -- Creates a forecasting context.
FCSET command -- Specifies the forecast characteristics.
FCEXEC command -- Executes a forecast and populates Oracle OLAP variables with forecasting data.
FCQUERY function -- Retrieves information about the characteristics of a forecast or a trial of a forecast.
FCCLOSE command -- Closes a forecasting context.
For examples of using these statements to forecast data see Example: A Forecasting Program.