Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
Within the general category of forecast and regression statements, the OLAP DML statements can be grouped in the following subcategories:
Simple forecasts and regressions
Forecasts and regressions using a forecasting context
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. |
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. |