@MOVSUM

Applies a moving sum to the specified number of values in an input data set. @MOVSUM modifies a data set for smoothing purposes.

Syntax

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

mbrName Any valid single member name or member combination, or a function that returns a single member or member combination.
n Optional. A positive integer value that represents the number of values to sum. The default is 3.
XrangeList 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, Analytic Services uses the level 0 members from the dimension tagged as time.

Notes

Example

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

"Mov Sum" = @MOVSUM(Sales,3,Jan:Jun);

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

This example produces the following report:

          Colas   New York   Actual		 
              Sales     Mov Sum	
              =====     =======	  
Jan            678        678	
Feb            645        645	
Mar            675       1998	
Apr            712       2032	
May            756       2143	
Jun            890       2358	

See Also

@MOVAVG
@MOVMAX
@MOVMED
@MOVMIN
@MOVSUMX
@TREND

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com