$STORETRIGGERVAL

The $STORETRIGGERVAL property specifies that when a $NATRIGGER expression executes, Oracle OLAP replaces the NA values in the variable with the results of the expression.

Note:

Most applications use the $VARCACHE property to specify that Oracle OLAP should store variable data that is the result of $NATRIGGER expression execution since the functionality of the $STORETRIGGERVAL property is subsumed within the $VARCACHE property.

See:

"How Oracle OLAP Determines Whether to Store or Cache Results of $NATRIGGER" for a discussion of all of the factors that Oracle OLAP uses to determine what to do with variable data that is the result of $NATRIGGER expression execution.

The PROPERTY command for general information on using properties in the OLAP DML.

Syntax

You add or delete a $STORETRIGGERVAL property to the most recently defined or considered object (see DEFINE PROGRAM and CONSIDER) using a PROPERTY statement with the following syntax.

PROPERTY {addproperty | deleteproperty}

where

addproperty has the following syntax.

'$STORETRIGGERVAL' value
deleteproperty has the following syntax.

DELETE '$STORERIGGERVAL'

Arguments

value

A BOOLEAN expression that contains the value of the property.

DELETE $STORETRIGGERVAL

Deletes the $STORETRIGGERVAL property.

You can also delete the $STORETRIGGERVAL property along with all properties from an object by issuing a PROPERTY DELETE ALL statement.

Notes

Relationship With the TRIGGERSTOREOK Option and $NATRIGGER Property

To permanently replace the NA values in the cells of a variable for which you have set an $AGGREGATE_FROM property, you must set the TRIGGERSTOREOK option setting to YES and you must set the $STORETRIGGERVAL property of the variable to the Boolean value YES. When the $STORETRIGGERVAL property for the variable has a Boolean value of NO, then Oracle OLAP does not replace the NA values in the cells of the variable with the $NATRIGGER expression value.

When the value of the TRIGGERSTOREOK option is NO, then Oracle OLAP does not replace the NA values in the cells of the variable with the $AGGREGATE_FROM expression value, even when the value of the $STORETRIGGERVAL property for the variable is YES.

Examples

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