$STORETRIGGERVAL

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

value: A BOOLEAN expression that contains the value of the property.

Examples

Example 6-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