Calculation Function List

Essbase includes powerful calculation features for demanding analytic requirements. A rich library of calculation functions makes it easy to define advanced and sophisticated business logic and relationships.

Click here for a categorical list.

Alphabetical List of Calculation Functions
@ABS	@EXP	@ISMBR	@MINRANGE	@RETURN
@ACCUM	@EXPAND	@ISMBRUDA	@MINS	@ROUND
@ALLANCESTORS	@FACTORIAL	@ISMBRWITHATTR	@MINSRANGE	@RSIBLINGS
@ALIAS	@FORMATDATE	@ISPARENT	@MOD	@SANCESTVAL
@ALLOCATE	@GEN	@ISRANGENONEMPTY	@MODE	@SHARE
@ANCEST	@GENMBRS	@ISSAMEGEN	@MOVAVG	@SHIFT
@ANCESTORS	@GRIDTUPLES	@ISSAMELEV	@MOVMAX	@SHIFTMINUS
@ANCESTVAL	@GROWTH	@ISSIBLING	@MOVMED	@SHIFTPLUS
@ATTRIBUTE	@IALLANCESTORS	@ISUDA	@MOVMIN	@SHIFTSIBLING
@ATTRIBUTEBVAL	@IANCESTORS	@LANCESTORS	@MOVSUM	@SIBLINGS
@ATTRIBUTESVAL	@ICHILDREN	@LDESCENDANTS	@MOVSUMX	@SLN
@ATTRIBUTEVAL	@IDESCENDANTS	@LEV	@NAME	@SPARENTVAL
@AVG	@ILANCESTORS	@LEVMBRS	@NEXT	@SPLINE
@AVGRANGE	@ILDESCENDANTS	@LIKE	@NEXTS	@STDEV
@BETWEEN	@ILSIBLINGS	@LIST	@NEXTSIBLING	@STDEVP
@CALCMODE	@INT	@LN	@NONEMPTYTUPLE	@STDEVRANGE
@CHILDREN	@INTEREST	@LOG	@NOTEQUAL	@SUBSTRING
@COMPOUND	@INTERSECT	@LOG10	@NPV	@SUM
@COMPOUNDGROWTH	@IRDESCENDANTS	@LSIBLINGS	@PARENT	@SUMRANGE
@CONCATENATE	@IRR	@MATCH	@PARENTVAL	@SYD
@CORRELATION	@IRREX	@MAX	@POWER	@TODATE
@COUNT	@IRSIBLINGS	@MAXRANGE	@PREVSIBLING	@TODATEEX
@CREATEBLOCK	@ISACCTYPE	@MAXS	@PRIOR	@TODAY
@CURGEN	@ISANCEST	@MAXSRANGE	@PRIORS	@TREND
@CURLEV	@ISATTRIBUTE	@MBRCOMPARE	@PTD	@TRUNCATE
@CURRMBR	@ISCHILD	@MBRPARENT	@QUERYBOTTOMUP	@UDA
@CURRMBRRANGE	@ISDESC	@MDALLOCATE	@RANGE	@VAR
@DATEDIFF	@ISGEN	@MDANCESTVAL	@RANGEFIRSTVAL	@VARPER
@DATEPART	@ISIANCEST	@MDPARENTVAL	@RANGELASTVAL	@VARIANCE
@DATEROLL	@ISIBLINGS	@MDSHIFT	@RANK	@VARIANCEP
@DECLINE	@ISICHILD	@MEDIAN	@RDESCENDANTS	@WEIGHTEDSUMX
@DESCENDANTS	@ISIDESC	@MEMBER	@RELATIVE	@WITHATTR
@DISCOUNT	@ISIPARENT	@MEMBERAT	@RELXRANGE	@XRANGE
@ENUMVALUE	@ISISIBLING	@MERGE	@REMAINDER	@XREF
@EQUAL	@ISLEV	@MIN	@REMOVE	@XWRITE