Supported Essbase Functions

This section lists the Essbase functions that are supported for configurable calculations and on-demand 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 N
@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 N
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 non-aggregated dimensions (for example, Movement, Intercompany, Multi-GAAP and Custom(s). It is required only if you need to reference an aggregated intersection in the middle of your custom calculation.