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:

• Simple forecasts and regressions

• Forecasts and regressions using a forecasting context

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.