Functional Commands

Use the functional commands in Essbase calculation scripts to perform operations such as calculation, data copying, exporting data, and clearing data.

The following is the list of functional commands:

• AGG

• CALC ALL

• CALC AVERAGE

• CALC DIM

• CALC FIRST

• CALC LAST

• CALC TWOPASS

• CLEARBLOCK

• CLEARDATA

• DATACOPY

• DATAEXPORT

• DATAEXPORTCOND

• DATAIMPORTBIN

• SET DATAEXPORTOPTIONS

• SET DATAIMPORTIGNORETIMESTAMP

• SET AGGMISSG

• SET CACHE

• SET CLEARUPDATESTATUS

• SET FRMLBOTTOMUP

• SET FRMLRTDYNAMIC

• SET MSG

• SET NOTICE

• SET REMOTECALC

• SET RUNTIMESUBVARS

• SET UPDATECALC

• USE_MDX_INSERT(for aggregate storage custom calculations only)