Skip Headers

Oracle® OLAP DML Reference
10g Release 1 (10.1)

Part Number B10339-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

A.8 Forecast and Regression Statements

Within the general category of forecast and regression statements, the OLAP DML statements can be grouped in the following subcategories:

A.8.1 Simple Forecasts and Regressions

Table A-14, "Statements for Simple Forecasts and Regressions" lists the OLAP DML that you use to calculate simple forecasts and regressions.

Table A-14 Statements for Simple Forecasts and Regressions

Statement Description
FORECAST
Forecasts data by one of three methods: straight-line trend, exponential growth, or Holt-Winters extrapolation.
FORECAST.REPORT
A program that produces a standard report of a forecast generated using the FORECAST command.
INFO
Obtains information that has been produced by the FORECAST command or the REGRESS command.
REGRESS
Calculates a simple multiple linear regression or a weighted regression.
REGRESS.REPORT
A program that produces a standard report of a regression created using the REGRESS command.
SMOOTH
Computes a single or a double exponential smoothing of a numeric expression.

A.8.2 Statements for Forecasting Using a Forecasting Context

Table A-15, "Statements for Forecasting Using a Forecasting Context" lists the OLAP DML that you use to calculate a sophisticated forecast using a forecasting context. Typically, you use these statements in an OLAP DML program in the order in which they are listed.

Table A-15 Statements for Forecasting Using a Forecasting Context

Statement Description
FCOPEN
Creates a forecasting context and returns a handle to this context.
FCSET
Sets the values of various parameters that determine the characteristics of the forecast.
FCEXEC
Executes a forecast based on the parameters options specified by the FCSET command for the forecast.
FCQUERY
Returns the results of a forecast created when the FCEXEC command executed.
FCCLOSE
Closes a forecasting context.