System Properties by Category

Within this document there are reference topics for system properties that you can use to specify behavior when:

• Aggregating or allocating data. See Table A-1, "System Properties Used When Aggregating or Allocating Data".

• Data cells are empty. See Table A-2, "System Properties Used When Working with NA Values".

• Creating multi-language programs and applications. See $DEFAULT_LANGUAGE.

System Properties Used When Aggregating Data

Table A-1, "System Properties Used When Aggregating or Allocating Data" lists system properties that relate to aggregation or allocation.

Table A-1 System Properties Used When Aggregating or Allocating Data

Property	Description
$AGGMAP	Specifies that Oracle OLAP use the identified aggmap to automatically aggregate non-precomuted data to substitute for NA values that are in the dimensioned variable, but not in the session cache for the variable (if any).
AGGREGATE_FORCECALC	Specifies that any value that is not specified in a PRECOMPUTE clause of a RELATION (for aggregation) statement in the aggmap of a variable should be recalculated when an AGGREGATE function executes, even when there is a value stored in the desired cell.
$AGGREGATE_FORCEORDER	Specifies that the calculation must be performed in the order in which the RELATION (for aggregation) statements are listed in the aggmap.
$AGGREGATE_FROM	Specifies the name of an object from which to obtain detail data when aggregating data.
$AGGREGATE_FROMVAR	Specifies the objects from which to obtain detail data when aggregating data.
$ALLOCMAP	Specifies the default allocation specification for a variable.
$COUNTVAR	Specifies that Oracle OLAP counts the number of leaf nodes that contributed to an aggregate value when an AGGREGATE function executes.
$VARCACHE	Specifies whether Oracle OLAP stores or caches variable data that is the result of the execution of a AGGREGATE function or $NATRIGGER expression.

System Properties that You Use with NA Values

Table A-2, "System Properties Used When Working with NA Values" lists system properties that you use when working with empty cells.

Table A-2 System Properties Used When Working with NA Values

Property	Description
$NATRIGGER	Sspecifies values to substitute for NA values that are in the object, but not in the session cache for the object (if any). (Note that the $AGGMAP property works in a similar fashion when you want to trigger the aggregation of values.)
$STORETRIGGERVAL	Specifies that NA values in an object be permanently replaced by the values specified by the $NATRIGGER property.
$VARCACHE	Specifies whether Oracle OLAP stores or caches variable data that is the result of the execution of a AGGREGATE function or $NATRIGGER expression.