Skip Headers
Oracle® OLAP DML Reference
10g Release 2 (10.2)

Part Number B14346-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

System Properties by Category

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

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.