This section discusses identifiers in DeepSee MDX.
MDX Identifiers and Allowed Variations
Every cube, subject area, relationship, dimension, hierarchy, level, member, property, and measure has an identifier.
Each MDX identifier has one of the following forms:
You can use this form if name
follows these rules:
The first character must be either an alphabetic character (Latin-1) or the underscore character (_
In DeepSee MDX, the first character can be numeric if the rest of the characters are also numeric. This InterSystems extension to MDX means that you can conveniently refer to members that have all-numeric names (such as postal codes).
The other characters must be either alphabetic characters, the underscore character, or numeric characters.
The name must not be an MDX reserved keyword. Reserved keywords are not case-sensitive in MDX.
You must use this form if name
does not follow the preceding rules. If name
includes a right square bracket (]
), you must escape that by using two right square brackets together (]]
Note that name
and key value
are not expressions. That is, you cannot replace them with string-valued expressions.