A.3 Assignment Statements

Table A-3, "Assignment Statements" lists the OLAP DML statements that you use to assign values to objects.

Table A-3 Assignment Statements

Statement	Description
SET	Assigns one or more values to a variable, relation, dimension surrogate, worksheet, valueset, or option. When an object has one or more dimensions, the SET command loops over the values in status for each dimension of the target object and assigns a data value to the corresponding cell of the target object
SET1	Assigns a single value to a variable, option, relation, or dimension surrogate. When an object has one or more dimensions, the SET1 command assigns the value to the object cell that is in current status.
MAINTAIN ADD	Adds new TEXT, ID, and INTEGER values to a non-concat dimension or a composite; or adds a new temporary calculated member to a dimension.
UNRAVEL	When used in conjunction with SET, copies the values of an expression into the cells of a variable when the dimensions of the expression are not the same as the dimensions of the variable.