Applies a smoothing spline to a set of data points. A spline is a mathematical curve that smoothes or interpolates data.
@SPLINE (YmbrName [, s [, XmbrName [, XrangeList]]])
YmbrName | A valid single member name that contains the dependent variable values used (when crossed with rangeList) to construct the spline. |
s | Optional. A zero (0) or positive value that determines the smoothness parameter. The default value is 1.0. |
XmbrName | Optional. A valid single member name that contains the independent variable values used (when crossed with rangeList) to construct the spline. The default independent variable values are 0,1,2,3, and so on. |
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. |
#MISSING
values in YmbrName
and XmbrName; in the result, Analytic Services replaces the #MISSING
values of YmbrName with the spline values.The following example is based on the Sample Basic database. Assume that the Measures dimension contains an additional member, Sales Spline. The formula calculates the spline of Sales values for Jan through Jun, based on a smoothness parameter of 2.
"Sales Spline" = @SPLINE(Sales,2,,Jan:Jun);
This example produces the following report:
Colas Actual New York Sales Sales Spline ===== ============ Jan 645 632.8941564 Feb 675 675.8247101 Mar 712 724.7394598 Apr 756 784.2860765 May 890 852.4398456 Jun 912 919.8157517
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |