|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
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. For more information on looping in OLAP_TABLE, see the discussion of the LOOP Clause.
To add the property, issue the following statement.
PROPERTY '$LOOP_VAR' qdr | variable
To delete the property, issue the following statement.
PROPERTY DELETE '$LOOP_VAR'
A QDR for one of the dimensions of the formula.
A variable with the same dimensions as the formula.