Calculation Command List

An Essbase calculation script contains a series of calculation commands, equations, and formulas. Use a calculation script for a block storage database when you want to perform a default calculation (CALC ALL) of the database, or to run calculations you developed using any of the following commands.

• & (ampersand)

• AGG

• ARRAY

• CALC ALL

• CALC AVERAGE

• CALC DIM

• CALC FIRST

• CALC LAST

• CALC TWOPASS

• CCONV

• CLEARBLOCK

• CLEARCCTRACK

• CLEARDATA

• DATACOPY

• DATAEXPORT

• DATAEXPORTCOND

• DATAIMPORTBIN

• DATAMERGE

• ELSE

• ELSEIF

• ENDIF

• EXCLUDE…ENDEXCLUDE

• FIX…ENDFIX

• FIXPARALLEL...ENDFIXPARALLEL

• IF

• LOOP...ENDLOOP

• POSTFIXPARALLEL

• SET Commands

• SET AGGMISSG

• SET CACHE

• SET CALCDIAGNOSTICS

• SET CALCPARALLEL

• SET CALCTASKDIMS

• SET CCTRACKCALC

• SET CLEARUPDATESTATUS

• SET COPYMISSINGBLOCK

• SET CREATEBLOCKONEQ

• SET CREATENONMISSINGBLK

• SET DATAEXPORTOPTIONS

• SET DATAIMPORTIGNORETIMESTAMP

• SET EMPTYMEMBERSETS

• SET FRMLBOTTOMUP

• SET FRMLRTDYNAMIC

• SET HYBRIDBSOINCALCSCRIPT

• SET MSG

• SET NOTICE

• SET REMOTECALC

• SET RUNTIMESUBVARS

• SET SCAPERSPECTIVE

• SET TRACE

• SET UPDATECALC

• SET UPTOLOCAL

• THREADVAR

• USE_MDX_INSERT (for aggregate storage custom calculations only)

• VAR