Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Expressions (DMX)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

In Data Mining Extensions (DMX), an expression is a combination of identifiers, values, and operators that Microsoft SQL Server Analysis Services can evaluate to obtain a result.

A DMX expression can be simple or complex. A simple expression can be one of the following:


A constant is symbol that represents a single, specific value. A constant can be a string, or a numeric or date value. You must use single quotation marks (') to delimit string and date constants.

Scalar Function

A scalar function returns a single value.

Non-Scalar Function

A non-scalar function returns a table.

Object Identifier

Object identifiers are considered to be simple expressions in DMX.

To build complex expressions, you can use operators to combine these expressions. For more information about operators, see Data Mining Extensions (DMX) Operator Reference.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft