|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
The $LOOP_DENSE property is used to determine how to loop the formula on which it is assigned when a OLAP_TABLE SQL function with the LOOP OPTIMIZED clause is executed. It specifies that Oracle OLAP loops densely over the formula (that is, that it loop over every tuple of the formula—even those member cells that do not have values).
See: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_DENSE' dimension_list
To delete the property, issue the following statement.
PROPERTY DELETE '$LOOP_DENSE'
One or more names of the dimensions of the formula separated by commas.