Forecasting Functions

Essbase forecasting functions allow you to manipulate data for the purposes of interpolating data or calculating future values.

Table 17-13 List of Forecasting Functions

Function	Data Manipulation
@MOVAVG	Apply a moving average to a data set and replace each term in the list with a trailing average. This function modifies the data set for smoothing purposes.
@MOVMAX	Apply a moving maximum to a data set and replace each term in the list with a trailing maximum. This function modifies the data set for smoothing purposes.
@MOVMED	Apply a moving median to a data set and replace each term in the list with a trailing median. This function modifies the data set for smoothing purposes.
@MOVMIN	Apply a moving minimum to a data set and replace each term in the list with a trailing minimum. This function modifies the data set for smoothing purposes.
@MOVSUM	Apply a moving sum to a data set and replace each term with a trailing sum. This function modifies the data set for smoothing purposes.
@MOVSUMX	Apply a moving sum to a data set and replace each term with a trailing sum. Specify how to assign values to members before you reach the number to sum. This function modifies the data set for smoothing purposes.
@SPLINE	Apply a smoothing spline to a set of data points. A spline is a mathematical curve that is used to smooth or interpolate data.
@TREND	Calculate future values and base the calculation on curve-fitting to historical values.