MDX expression syntax

An MDX expression consists of one or more identifiers, literal values, function calls, and other expressions, connected by operators. An expression evaluates to a value that is one of the data types of MDX.
Read syntax diagramSkip visual syntax diagram
   .-| Operator |----------.   
   V                       |   
>>---+-| Identifier |----+-+-----------------------------------><
     +-| Literal |-------+     
     '-| Function call |-'     

Identifier
A reference to an object of one of the data types of MDX. An identifier can consist only of letters, numbers, and the underscore (_); the first character of an identifier must be a letter or an underscore (_). You must enclose an identifier in brackets ([ and ]) if the identifier is a reserved word in MDX or if the identifier contains a space character.
Literal
A reference to a value of one of the data types of MDX. Each data type has its own notation for literal references.
Function call
A call to an MDX function. Each function has its own syntax.
Operator
A non-comment operator, such as + or And. Operators join two expressions together, with one exception: the Not operator takes only one operand expression.


Feedback | Information roadmap

https://www.ibm.com/docs/en/db2/10.1.0