Supported Essbase Functions
This section lists the Essbase functions that are supported for configurable calculations and ondemand rules in Financial Consolidation and Close. "Y" indicates that the function is supported.
For detailed function information, see Oracle Essbase Technical Reference.
Common Essbase Functions

FIX / ENDFIX  control scope

Calculation Member Block

Member Set: @LIST, @REMOVE, @RELATIVE, @CURRMBR, @CHILDREN, @DESCENDANTS, @SIBLINGS

Conditional and Logical Operators: IF...ENDIF, < >, +, AND, OR, NOT

Boolean: @ISMBR, @ISUDA, @ISACCTYPE, @SCHILD, @ISLEV, @ISANCEST

Relationship: @GEN, @LEV, @CURGEN, @CURLEV

Mathematical: @ABS, @SUM, @VAR, @ROUND, @MAX, +  * /
Essbase Construct  Category  Sub Category  Supported 

IF  Calculation Functions  Conditional and Logical Operators  Y 
ELSE  Calculation Functions  Conditional and Logical Operators  Y 
ELSE IF  Calculation Functions  Conditional and Logical Operators  Y 
ENDIF  Calculation Functions  Conditional and Logical Operators  Y 
>  Calculation Functions  Conditional and Logical Operators  Y 
>=  Calculation Functions  Conditional and Logical Operators  Y 
<  Calculation Functions  Conditional and Logical Operators  Y 
<=  Calculation Functions  Conditional and Logical Operators  Y 
= =  Calculation Functions  Conditional and Logical Operators  Y 
< >  Calculation Functions  Conditional and Logical Operators  Y 
!=  Calculation Functions  Conditional and Logical Operators  Y 
AND  Calculation Functions  Conditional and Logical Operators  Y 
OR  Calculation Functions  Conditional and Logical Operators  Y 
NOT  Calculation Functions  Conditional and Logical Operators  Y 
@ISACCTYPE  Calculation Functions  Boolean  Y (See Note following table) 
@ISANCEST  Calculation Functions  Boolean  N 
@ISCHILD  Calculation Functions  Boolean  Y 
@ISDESC  Calculation Functions  Boolean  Y 
@ISGEN  Calculation Functions  Boolean  Y 
@ISIANCEST  Calculation Functions  Boolean  Y 
@ISICHILD  Calculation Functions  Boolean  Y 
@ISIDESC  Calculation Functions  Boolean  Y 
@ISIPARENT  Calculation Functions  Boolean  Y 
@ISISIBLING  Calculation Functions  Boolean  Y 
@ISLEV  Calculation Functions  Boolean  Y 
@ISMBR  Calculation Functions  Boolean  Y 
@ISMBRUDA  Calculation Functions  Boolean  Y 
@ISPARENT  Calculation Functions  Boolean  Y 
@ISRANGENONEMPTY  Calculation Functions  Boolean  Y 
@ISSAMEGEN  Calculation Functions  Boolean  Y 
@ISSAMELEV  Calculation Functions  Boolean  Y 
@ISSIBLING  Calculation Functions  Boolean  Y 
@ISUDA  Calculation Functions  Boolean  Y 
@ANCESTVAL  Calculation Functions  Relationship  N 
@ATTRIBUTEBVAL  Calculation Functions  Relationship  N 
@ATTRIBUTESVAL  Calculation Functions  Relationship  N 
@ATTRIBUTEVAL  Calculation Functions  Relationship  N 
@CURGEN  Calculation Functions  Relationship  Y 
@CURLEV  Calculation Functions  Relationship  Y 
@GEN  Calculation Functions  Relationship  Y 
@LEV  Calculation Functions  Relationship  Y 
@MDANCESTVAL  Calculation Functions  Relationship  N 
@MDPARENTVAL  Calculation Functions  Relationship  N 
@PARENTVAL  Calculation Functions  Relationship  Y 
@SANCESTVAL  Calculation Functions  Relationship  N 
@SPARENTVAL  Calculation Functions  Relationship  N 
@XREF  Calculation Functions  Relationship  Y 
@XWRITE  Calculation Functions  Relationship  N 
@ABS  Calculation Functions  Mathematical  Y 
@AVG  Calculation Functions  Mathematical  N 
@EXP  Calculation Functions  Mathematical  N 
@FACTORIAL  Calculation Functions  Mathematical  N 
@INT  Calculation Functions  Mathematical  N 
@LN  Calculation Functions  Mathematical  N 
@LOG  Calculation Functions  Mathematical  N 
@LOG10  Calculation Functions  Mathematical  N 
@MAX  Calculation Functions  Mathematical  N 
@MAXS  Calculation Functions  Mathematical  N 
@MIN  Calculation Functions  Mathematical  Y 
@MINS  Calculation Functions  Mathematical  N 
@MOD  Calculation Functions  Mathematical  Y 
@POWER  Calculation Functions  Mathematical  Y 
@REMAINDER  Calculation Functions  Mathematical  Y 
@ROUND  Calculation Functions  Mathematical  Y 
@SUM  Calculation Functions  Mathematical  Y 
@TRUNCATE  Calculation Functions  Mathematical  Y 
@VAR  Calculation Functions  Mathematical  Y 
@VARPER  Calculation Functions  Mathematical  N 
@ALLANCESTORS  Calculation Functions  Member set  N 
@ANCEST  Calculation Functions  Member set  Y 
@ANCESTORS  Calculation Functions  Member set  Y 
@ATTRIBUTE  Calculation Functions  Member set  Y 
@BETWEEN  Calculation Functions  Member set  N 
@CHILDREN  Calculation Functions  Member set  Y 
@CURRMBR  Calculation Functions  Member set  Y 
@DESCENDANTS  Calculation Functions  Member set  Y 
@EQUAL  Calculation Functions  Member set  Y 
@EXPAND  Calculation Functions  Member set  N 
@GENMBRS  Calculation Functions  Member set  Y 
@IALLANCESTORS  Calculation Functions  Member set  Y 
@IANCESTORS  Calculation Functions  Member set  Y 
@ICHILDREN  Calculation Functions  Member set  Y 
@IDESCENDANTS  Calculation Functions  Member set  Y 
@ILANCESTORS  Calculation Functions  Member set  Y 
@ILDESCENDANTS  Calculation Functions  Member set  N 
@ILSIBLINGS  Calculation Functions  Member set  Y 
@INTERSECT  Calculation Functions  Member set  Y 
@IRSIBLINGS  Calculation Functions  Member set  Y 
@IRDESCENDANTS  Calculation Functions  Member set  Y 
@ISIBLINGS  Calculation Functions  Member set  Y 
@LANCESTORS  Calculation Functions  Member set  Y 
@LDESCENDANTS  Calculation Functions  Member set  Y 
@LEVMBRS  Calculation Functions  Member set  Y 
@LIST  Calculation Functions  Member set  Y 
@LSIBLINGS  Calculation Functions  Member set  Y 
@MATCH  Calculation Functions  Member set  Y 
@MBRCOMPARE  Calculation Functions  Member set  Y 
@MBRPARENT  Calculation Functions  Member set  Y 
@MEMBER  Calculation Functions  Member set  Y 
@MEMBERAT  Calculation Functions  Member set  Y 
@MERGE  Calculation Functions  Member set  Y 
@NEXTSIBLING  Calculation Functions  Member set  Y 
@NOTEQUAL  Calculation Functions  Member set  Y 
@PARENT  Calculation Functions  Member set  Y 
@PREVSIBLING  Calculation Functions  Member set  Y 
@RANGE  Calculation Functions  Member set  Y 
@RDESCENDANTS  Calculation Functions  Member set  Y 
@RELATIVE  Calculation Functions  Member set  Y 
@REMOVE  Calculation Functions  Member set  Y 
@RSIBLINGS  Calculation Functions  Member set  Y 
@SHIFTSIBLING  Calculation Functions  Member set  N 
@SIBLINGS  Calculation Functions  Member set  Y 
@UDA  Calculation Functions  Member set  Y 
@WITHATTR  Calculation Functions  Member set  N 
@ACCUM  Calculation Functions  Range and Financial  Y 
@AVGRANGE  Calculation Functions  Range and Financial  Y 
@COMPOUND  Calculation Functions  Range and Financial  Y 
@COMPOUNDGROWTH  Calculation Functions  Range and Financial  N 
@CURRMBRRANGE  Calculation Functions  Range and Financial  Y 
@DECLINE  Calculation Functions  Range and Financial  N 
@GROWTH  Calculation Functions  Range and Financial  N 
@INTEREST  Calculation Functions  Range and Financial  Y 
@IRR  Calculation Functions  Range and Financial  Y 
@IRREX  Calculation Functions  Range and Financial  N 
@MAXRANGE  Calculation Functions  Range and Financial  Y 
@MAXSRANGE  Calculation Functions  Range and Financial  N 
@MDSHIFT  Calculation Functions  Range and Financial  N 
@MINRANGE  Calculation Functions  Range and Financial  Y 
@MINSRANGE  Calculation Functions  Range and Financial  N 
@NEXT  Calculation Functions  Range and Financial  Y 
@NEXTS  Calculation Functions  Range and Financial  N 
@NPV  Calculation Functions  Range and Financial  Y 
@PTD  Calculation Functions  Range and Financial  N 
@PRIOR  Calculation Functions  Range and Financial  Y 
@PRIORS  Calculation Functions  Range and Financial  N 
@RANGE  Calculation Functions  Range and Financial  Y 
@RANGEFIRSTVAL  Calculation Functions  Range and Financial  Y 
@RANGELASTVAL  Calculation Functions  Range and Financial  Y 
@SHIFT  Calculation Functions  Range and Financial  Y 
@SHIFTPLUS  Calculation Functions  Range and Financial  Y 
@SHIFTMINUS  Calculation Functions  Range and Financial  Y 
@SLN  Calculation Functions  Range and Financial  N 
@SUMRANGE  Calculation Functions  Range and Financial  Y 
@SYD  Calculation Functions  Range and Financial  N 
@XRANGE  Calculation Functions  Range and Financial  Y 
@ALLOCATE  Calculation Functions  Allocation  N 
@MDALLOCATE  Calculation Functions  Allocation  N 
@MOVAVG  Calculation Functions  Forecasting  N 
@MOVMAX  Calculation Functions  Forecasting  N 
@MOVMED  Calculation Functions  Forecasting  N 
@MOVMIN  Calculation Functions  Forecasting  N 
@MOVSUM  Calculation Functions  Forecasting  N 
@MOVSUMX  Calculation Functions  Forecasting  N 
@SPLINE  Calculation Functions  Forecasting  N 
@TREND  Calculation Functions  Forecasting  N 
@CORRELATION  Calculation Functions  Statistical  N 
@COUNT  Calculation Functions  Statistical  Y 
@MEDIAN  Calculation Functions  Statistical  N 
@MODE  Calculation Functions  Statistical  N 
@RANK  Calculation Functions  Statistical  N 
@STDEV  Calculation Functions  Statistical  N 
@STDEVP  Calculation Functions  Statistical  N 
@STDEVRANGE  Calculation Functions  Statistical  N 
@VARIANCE  Calculation Functions  Statistical  N 
@VARIANCEP  Calculation Functions  Statistical  N 
@TODATE  Calculation Functions  Date & Time  Y 
@CALCMODE  Calculation Functions  Misc  Y 
@CONCATENATE  Calculation Functions  Misc  Y 
@SUBSTRING  Calculation Functions  Misc  Y 
@NAME  Calculation Functions  Misc  Y 
@RETURN  Calculation Functions  Misc  N 
@CREATEBLOCK  Calculation Functions  Misc  Y 
+ (Adds)  Calculation Commands  Mathematical  Y 
 (Subtracts)  Calculation Commands  Mathematical  Y 
* (Multiplies)  Calculation Commands  Mathematical  Y 
/ (Divides)  Calculation Commands  Mathematical  Y 
% (Evaluates Percentage)  Calculation Commands  Mathematical  Y 
( ) (Controls the calculation order)  Calculation Commands  Mathematical  Y 
AGG  Calculation Commands  Misc  N 
ARRAY  Calculation Commands  Misc  Y 
CALC ALL  Calculation Commands  CALC  N 
CALC AVERAGE  Calculation Commands  CALC  N 
CALC DIM  Calculation Commands  CALC  Y (See Note following table) 
CALC FIRST  Calculation Commands  CALC  N 
CALC LAST  Calculation Commands  CALC  N 
CALC TWOPASS  Calculation Commands  Misc  N 
CCONV  Calculation Commands  CLEAR  N 
CLEARBLOCK  Calculation Commands  CLEAR  Y 
CLEARCCTRACK  Calculation Commands  CLEAR  N 
CLEARDATA  Calculation Commands  CLEAR  Y 
DATACOPY  Calculation Commands  COPY  Y 
DATAEXPORT  Calculation Commands  EXPORT  N 
DATAEXPORTCOND  Calculation Commands  EXPORT  N 
DATAIMPORTBIN  Calculation Commands  EXPORT  N 
EXCLUDE...ENDEXCLUDE  Calculation Commands  BLOCK  N 
FIX...ENDFIX  Calculation Commands  BLOCK  Y 
FIXPARALLEL...ENDFIXPARALLEL  Calculation Commands  BLOCK  N 
LOOP...ENDLOOP  Calculation Commands  BLOCK  Y 
POSTFIXPARALLEL  Calculation Commands  BLOCK  N 
SET AGGMISSG  Calculation Commands  SET  N 
SET CACHE  Calculation Commands  SET  N 
SET CALCDIAGNOSTICS  Calculation Commands  SET  N 
SET CALCPARALLEL  Calculation Commands  SET  N 
SET CALCTASKDIMS  Calculation Commands  SET  N 
SET CCTRACKCALC  Calculation Commands  SET  N 
SET CLEARUPDATESTATUS  Calculation Commands  SET  N 
SET COPYMISSINGBLOCK  Calculation Commands  SET  N 
SET CREATEONMISSINGBLK  Calculation Commands  SET  N 
SET CREATEBLOCKONEQ  Calculation Commands  SET  N 
SET DATAEXPORTOPTIONS  Calculation Commands  SET  N 
SET DATAIMPORTIGNORETIMESTAMP  Calculation Commands  SET  N 
SET EMPTYMEMBERSETS  Calculation Commands  SET  N 
SET FRMLBOTTOMUP  Calculation Commands  SET  N 
SET FRMLRTDYNAMIC  Calculation Commands  SET  N 
SET LOCKBLOCK  Calculation Commands  SET  N 
SET MSG  Calculation Commands  SET  N 
SET NOTICE  Calculation Commands  SET  N 
SET REMOTECALC  Calculation Commands  SET  N 
SET RUNTIMESUBVARS  Calculation Commands  SET  N 
SET SCAPERSPECTIVE  Calculation Commands  SET  N 
SET UPDATECALC  Calculation Commands  SET  N 
SET UPTOLOCAL  Calculation Commands  SET  N 
THREADVAR  Calculation Commands  Misc  N 
VAR  Calculation Commands  Misc  Y 
Note:
@ISACCTYPE: This function only applies to Expense accounts. Any of these values may be used: First, Last, Average, Expense, and Twopass.
CALC DIM: You should only use CALC DIM on nonaggregated dimensions (for example, Movement, Intercompany, MultiGAAP and Custom(s). It is required only if you need to reference an aggregated intersection in the middle of your custom calculation.