Essbase Functions Supported by Calculation Manager

The following Oracle Essbase functions are supported by Calculation Manager in Block Storage applications.

Table 9-3 Essbase Functions Supported by Calculation Manager

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