Supported Functions and Outline Math for Calc on the Fly
Essbase calculation functions and outline math are supported in the member formulas used for calc on the fly.
Supported Outline Math
The following are supported for calc on the fly:
- All outline member consolidation operators as defined in the Essbase Technical Reference: add (+), subtract (-), multiply (*), divide (/), and percentage (%).
- Unary operators (+, -, *, /, %, ~) for consolidation: add, subtract, multiply, divide, percentile, and ignore.
- Subvars
- Time Balance calculations: First, Last, Average, SKIP NONE, and SKIP MISSING. Note that Fill is not supported.
Supported Functions
The following Essbase calculation functions are supported in member formulas for calc on the fly in the web application as well as in Oracle Smart View for Office.
Note:
- The functions that are not supported for calc on the fly are listed in Unsupported Functions and Formulas for Calc on the Fly.
- To learn more about the Essbase calculation functions, see Calculation Function List.
The supported functions listed below are grouped as per their function category:
IS Functions:
- @ISACCTYPE
- @ISANCEST
- @ISATTRIBUTE
- @ISCHILD
- @ISDESC
- @ISGEN
- @ISIANCEST
- @ISICHILD
- @ISIDESC
- @ISIPARENT
- @ISISIBLING
- @ISLEV
- @ISMBR
- @ISMBRUDA
- @ISMBRWITHATTR
- @ISPARENT
- @ISSAMEGEN
- @ISSAMELEV
- @ISSIBLING
- @ISUDA
Numeric Functions:
- @ABS
- @AVG
- @CONCATENATE
- @COUNT
- @EXP
- @FACTORIAL
- @INT
- @LN
- @LOG
- @LOG10
- @MAX
- @MAXS
- @MEDIAN
- @MIN
- @MINS
- @MOD
- @MODE
- @POWER
- @RANK
- @REMAINDER
- @ROUND
- @SUBSTRING
- @SUM
- @TRUNCATE
- @VAR
- @VARPER
Member Selection Functions:
- @ALLANCESTORS
- @ANCEST
- @ANCESTORS
- @ATTRIBUTE
- @BETWEEN
- @CHILDREN
- @CURRMBR
- @CURRMBRRANGE
- @DESCENDANTS
- @EQUAL
- @EXPAND
- @GENMBRS
- @IALLANCESTORS
- @IANCESTORS
- @ICHILDREN
- @IDESCENDANTS
- @ILANCESTORS
- @ILDESCENDANTS
- @ILSIBLINGS
- @INTERSECT
- @IRDESCENDANTS
- @IRSIBLINGS
- @ISIBLINGS
- @LANCESTORS
- @LDESCENDANTS
- @LEVMBRS
- @LIKE
- @LIST
- @LSIBLINGS
- @MATCH
- @MBRCOMPARE
- @MBRPARENT
- @MEMBER
- @MERGE
- @NAME
- @NEXTSIBLING
- @NOTEQUAL
- @PARENT
- @PREVSIBLING
- @RDESCENDANTS
- @RELATIVE
- @REMOVE
- @RSIBLINGS
- @SHIFTSIBLING
- @SIBLINGS
- @UDA
- @WITHATTR
Value Functions:
- @ANCESTVAL
- @ATTRIBUTEBVAL
- @ATTRIBUTESVAL
- @ATTRIBUTEVAL
- @CURGEN
- @CURLEV
- @GEN
- @LEV
- @PARENTVAL
Range Functions:
- @XRANGE
- @RANGE
- @ACCUM
- @MAXRANGE
- @MINRANGE
- @NEXT
- @PRIOR
- @SHIFT
- @SUMRANGE
- @MOVSUMX
- @MOVSUM
- @MOVAVG
- @MOVMIN
- @MOVMAX
- @MOVMED
- @AVGRANGE
- @MAXSRANGE
- @MINSRANGE
- @NEXTS
- @PRIORS
- @RANGEFIRSTVAL
- @RANGELASTVAL