SET_PROPERTY

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"

Syntax

CALL SET_PROPERTY(property_name, logical_cube, meas_name, property_value)

Parameters

CALL: Because SET_PROPERTY is an OLAP DML program with arguments, you invoke it using the OLAP DML CALL statement.
property_name: A text expression that is either $LOOP_VAR or $LOOP_DENSE.
logical_cube: A text expression that is the Oracle data dictionary name of the cube that contains meas_name.

See also:
"Guidelines for Specifying Values for the Names of Logical OLAP Objects"
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.
property_value: A text expression that is a valid value for the property you specified in property_name. For valid values, see $LOOP_DENSE or $LOOP_VAR.