TechNet
Export (0) Print
Expand All

MDX Syntax Elements (MDX)

 

Updated: March 2, 2016

Multidimensional Expressions (MDX) has several elements that are used by, or influence, most statements:

TermDefinition
IdentifiersIdentifiers are the names of objects such as cubes, dimensions, members, and measures.
Data TypesDefine the types of data that are contained by cells, member properties, and cell properties. MDX supports only the OLE VARIANT data type. For more information about the coercion, conversion, and manipulation of the VARIANT data type, see "VARIANT and VARIANTARG" in the Platform SDK documentation.
Expressions (MDX)Expressions are units of syntax that Microsoft SQL Server Analysis Services can resolve to single (scalar) values or objects. Expressions include functions that return a single value, a set expression, and so on.
OperatorsOperators are syntax elements that work with one or more simple MDX expressions to make more complex MDX expressions.
FunctionsFunctions are syntax elements that take zero, one, or more input values, and return a scalar value or an object. Examples include the Sum function for adding several values, the Members function for returning a set of members from a dimension or level, and so on.
CommentsComments are pieces of text that are inserted into MDX statements or scripts to explain the purpose of the statement. Analysis Services does not execute comments .
Reserved KeywordsReserved keywords are words that are reserved for the use of MDX and should not be used for object names used in MDX statements.
Members, Tuples, and SetsMembers, tuples and sets are core concepts of multidimensional data that you must understand before you create an MDX query.

Multidimensional Expressions (MDX) Reference

Community Additions

ADD
Show:
© 2016 Microsoft