|Oracle® OLAP DML Reference
11g Release 2 (11.2)
Part Number E17122-05
The SET_PROPERTY program modifies the values of the $LOOP_DENSE or $LOOP_VAR properties of a derived measure of a cube as defined in the Oracle data dictionary. The changes made when this program executes are not transactional; an automatic COMMIT is executed as part of the program.
See also:"Cube-Aware OLAP DML Statements"
CALL SET_PROPERTY(property_name, logical_cube, meas_name, property_value)
Since SET_PROPERTY is an OLAP DML program with arguments, you invoke it using the OLAP DML CALL statement.
A text expression that is either $LOOP_VAR or $LOOP_DENSE.
A text expression that is the Oracle data dictionary name of the cube that contains meas_name.
A text expression that is the Oracle data dictionary name of the derived measure for which you want to modify the value of either the $LOOP_VAR or $LOOP_DENSE property.