Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-03 |
|
|
View PDF |
The $STORETRIGGERVAL property specifies whether or not, when a $NATRIGGER expression executes, Oracle OLAP replaces the NA
values in the variable with the results of the expression.
Note:
Applications typically use the $VARCACHE property rather than the $STORETRIGGERVAL property since the functionality of the $STORETRIGGERVAL property is subsumed within the $VARCACHE property.Syntax
You add or delete a $STORETRIGGERVAL property to the most recently defined or considered object (see DEFINE and CONSIDER) using a PROPERTY statement:
To add the property, issue the following statement.
PROPERTY '$STORETRIGGERVAL' value
To delete the property, issue the following statement.
PROPERTY DELETE '$ASTORETRIGGERVAL'
Arguments
A BOOLEAN expression that contains the value of the property.
Examples
Example 8-12 Storing an $NATRIGGER Property Value
The following statements cause Oracle OLAP to store the $NATRIGGER expression value in the NA
cells of the v1
variable when Oracle OLAP evaluates the expression.
TRIGGERSTOREOK = yes CONSIDER v1 PROPERTY '$STORETRIGGERVAL' yes