Assignment Statements |
Table: Assignment Statements lists the OLAP DML statements that you use to assign values to objects.
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. |