Supported Essbase Functions
This section lists the Essbase functions that are supported for configurable calculations in Financial Consolidation and Close. "Y" (for Yes) 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 | Y |
@MIN | Calculation Functions | Mathematical | Y |
@MINS | Calculation Functions | Mathematical | Y |
@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 | N |
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 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. Additionally, please refrain from using CALC DIM in DSO applications.