essbase @ACCUM

ccumulates the values of mbrName within rangeList, up to the current member in the dimension
of which rangeList is a part.

Syntax

@ACCUM (mbrName [, rangeList])
Parameter Description
mbrName Any valid single member name or member combination (or a function that
returns a single member or member combination) whose value is to be accumulated.
rangeList Optional comma-delimited list of members, member set functions, or range
functions, across which the accumulation occurs. If rangeList is
not specified, Essbase uses the level 0 members from
the dimension tagged as Time.

Notes

  • Financial functions never return a value; rather, they calculate
    a series of values internally based on the range specified.
  • @ACCUM accepts the @ATTRIBUTE member set function as a member
    range.
  • If you use an Essbase member set function
    to generate a member list for the rangeList parameter
    (for example, @SIBLINGS), to ensure correct results, consider the order in
    which Essbase sorts the generated member list. For
    more information, see the Oracle Essbase Technical Reference topic for the member set function you
    are using.
  • You cannot apply an operator (for example divide or multiply)
    to @Accum. For example, the formula Budget=@ACCUM(Actual, Jan:Feb)/2 is not
    valid.

Example

In this example, Accum Asset is calculated using the following formula:

"Accum Asset" = @ACCUM(Asset, FY1997:FY2002);

This example produces the following report. This report shows that the
values for Asset are accumulated starting with FY1997 and the yearly accumulation
value is placed in Accum Asset for FY1997 through FY2002:

             FY1997   FY1998   FY1999   FY2000   FY2001   FY2002
            =======  =======  =======  =======  =======  =======
Asset         9,000        0    1,000        0   2 ,500    1,500
Residual        750        0        0        0  #MISSING #MISSING
Life              5        0        3        0  #MISSING #MISSING
Accum Asset #MISSING #MISSING   1,000    1,000    3,500    5,000

The value of Accum Asset is #MISSING for FY1997 because that is the
starting year. The value of Accum Asset is #MISSING for FY1998 because there
was no accumulation that year. For FY1999, the value of the asset grew by
1,000, so Accum Asset has a value of 1000.