DeepSee MDX Reference
This section describes how to create and use string expressions
in DeepSee MDX.
In DeepSee MDX, a string expression can have any of the following
A string literal (a double quote character, followed
by any characters, followed by another double quote character). For
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: