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