Previous
Previous
 
Next
Next


$LOOP_VAR

The $LOOP_VAR property specifies that when a OLAP_TABLE SQL function with the LOOP OPTIMIZED clause is executed, the formula on which it is assigned is looped in the same manner as the variable or QDR specified in the property.


See also:

SET_PROPERTY

Syntax

You add or delete a $LOOP_VAR property to the most recently defined or considered formula (see DEFINE and CONSIDER commands) using a PROPERTY statement:

Parameters

qdr

A QDR for a dimension of the formula.

variable

A variable with the same dimensions as the formula.