InterSystems MDX Reference
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"
A numeric literal.
An expression that uses an MDX function to return a string. These functions include:
, which returns the value of a property of a member. For example: homed.city.magnolia.PROPERTIES("Population")
See the reference section “Intrinsic Properties
” for intrinsic properties that you can use.
, which returns one of two values, depending on the value of a given logical expression.
, which looks up a given key in a term list and returns a substitute string.
, which returns one value from a term list.
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")'
Then the expression MEASURES.stringtest is a string expression.
An expression that uses the MDX concatenation operator (+) to combine other string expressions. For example:
For another 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:
Where variablename 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:
Content Date/Time: 2019-09-20 05:36:42