System Properties by Category

The OLAP DML provides system properties that set or retrieve values that influence how the OLAP DML performs the following:

Aggregation Properties

Allocation Property

Grouping Id Properties

Formula Properties

Language Property

NA Value Properties

Aggregation Properties

$AGGMAP
$AGGREGATE_FORCECALC
$AGGREGATE_FORCEORDER
$AGGREGATE_FROM
$AGGREGATE_FROMVAR
$COUNTVAR
$VARCACHE

Allocation Property

$ALLOCMAP

Grouping Id Properties

$GID_DEPTH
$GID_LIST
$GID_TYPE

Formula Properties

$LOOP_AGGMAP
$LOOP_DENSE
$LOOP_VAR

Language Property

$DEFAULT_LANGUAGE

NA Value Properties

$NATRIGGER
$STORETRIGGERVAL
$VARCACHE