Applies a moving n-term minimum (lowest number) to an input data set. Each term in the list is replaced by a trailing minimum of n terms, and the first terms (the n-1 terms) are copies of the input data. @MOVMIN modifies a data set for smoothing purposes.


@MOVMIN (mbrName [, n [, XrangeList]])


Any valid single member name or member combination, or a function that returns a single member or member combination.


Optional. A positive integer value that represents the number of values that are used to calculate the moving minimum. The default is 3.


Optional. A valid member name, a comma-delimited list of member names, cross dimension members, or a member set function or range function (including @XRANGE) that returns a list of members from the same dimension. If XrangeList is not specified, Essbase uses the level 0 members from the dimension tagged as time.



The following example is based on the Sample Basic database. Assume that the Measures dimension contains an additional member, Mov Min.

"Mov Min" = @MOVMIN(Sales,3,Jan:Jun);

In this example, the @MOVMIN function smooths sales data for the first six months of the year (Jan through Jun). The results of @MOVMIN can be used with the @TREND function to forecast minimum sales data for the holiday season (for example, October - December).

This example produces the following report:

            Colas     New York    Actual
                Sales       Mov Min     
                =====       =======
Jan              678          678       
Feb              645          645       
Mar              675          645       
Apr              712          645       
May              756          675       
Jun              890          712       

In this example, Essbase uses three values at a time to calculate the moving minimum. The first two values (Jan,Feb) for Mov Min and the first two values for Sales are the same. The value for Mar represents the trailing minimum of Jan, Feb, and Mar. The value for Apr represents the trailing mimimum of Feb, Mar, and Apr. The remaining values represent the trailing minimum for each group of three values.

See Also