1. Calculation and Query Reference for Oracle Essbase
  2. Calculation Functions
  3. Calculation Function List
  4. @ACCUM

@ACCUM

The @ACCUM calculation function for Essbase accumulates the values of a member across a range.

Syntax

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

@ACCUM (mbrName [, rangeList])

Parameters

mbrName

Any valid single member name (or a function that returns a single member) 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.

  • 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.