System Properties that You Use with NA Values


Table: System Properties Used When Working with NA Values lists system properties that you use when working with empty cells.

System Properties Used When Working with NA Values

Property Description
$NATRIGGER A property that specifies values to substitute for NA values that are in the object, but not in the session cache for the object (if any).
$STORETRIGGERVAL
A property that specifies that NA values in an object be permanently replaced by the values specified by the $NATRIGGER property.
$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.