Coercion Rules for Numeric and String Values
The following table describes the coercion rules for
expressions or prompts that return a numeric or string value. These
rules apply to functions and operators that require an operand of a
particular data type, as well as to binary operators that require
operands of the same type.
| Source type | Target type | Result |
|---|---|---|
|
Measure |
Number, Date/Time, or String |
The result is the value of the measure at the current cube intersection. |
|
Member |
Number |
The result is the value of the cell at the cube intersection specified by the member. This coercion is done in two steps. First, members are coerced to tuples, and then tuples are coerced to the target type. |
|
Tuple |
Number |
The value of the cell at the cube intersection specified by the tuple. The equivalent expression is |