System Properties Used When Aggregating Data |
Table: System Properties Used When Aggregating or Allocating Data lists system properties that relate to aggregation or allocation.
System Properties Used When Aggregating or Allocating Data
| Property | Description |
|---|---|
| $AGGMAP
|
A property that specifies the default aggregation specification for a variable. |
| $AGGREGATE_FORCECALC
|
A property that 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
|
A property that specifies that the calculation must be performed in the order in which the RELATION (for aggregation) statements are listed in the aggmap. |
| $AGGREGATE_FROM | A property that specifies the name of an object from which to obtain detail data when aggregating data. |
| $AGGREGATE_FROMVAR | A property that specifies the objects from which to obtain detail data when aggregating data. |
| $ALLOCMAP
|
A property that specifies the default allocation specification for a variable. |
| $COUNTVAR
|
A property that specifies that Oracle OLAP counts the number of leaf nodes that contributed to an aggregate value when an AGGREGATE function executes. |
| $VARCACHE | A property that specifies whether Oracle OLAP stores or caches variable data that is the result of the execution of a AGGREGATE function or $NATRIGGER expression. |