Applies a moving sum to the specified number of values in an input data set. @MOVSUM modifies a data set for smoothing purposes.
@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. |
Trailing Sum Centered Sum 1 2 3 1 2 3 6 6
#MISSING
values.
For example, if one value out of three is #MISSING
, Analytic Services
adds the remaining two values. 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
@MOVAVG
@MOVMAX
@MOVMED
@MOVMIN
@MOVSUMX
@TREND
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |