This section describes how to create and use string expressions in InterSystems MDX.
In InterSystems MDX, a string expression can have any of the following forms:
A string literal (a double quote character, followed by any characters, followed by another double quote character). For example: "label"
or "my property"
An expression that uses an MDX function to return a string. These functions include:
An expression that refers to a string-valued measure. For example, suppose that you define a calculated member
CREATE MEMBER patients.measures.stringtest AS 'IIF(MEASURES.[avg test score]<60, "low","high")'
An expression that uses the MDX concatenation operator (+
) to combine other string expressions. For example:
"Pop: " + homed.city.magnolia.PROPERTIES("Population")
A reference to a pivot variable that contains a string value. To refer to a pivot variable, use the following syntax:
is the logical variable name. Do not enclose this expression with square brackets. This syntax is not case-sensitive; nor is the pivot variable name.
You can use string expressions in the following ways: