Skip to content

Latest commit

 

History

History
44 lines (34 loc) · 2.23 KB

expressions-dmx.md

File metadata and controls

44 lines (34 loc) · 2.23 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic ms.custom
Expressions (DMX)
Expressions (DMX)
minewiskan
owend
owend
02/17/2022
sql
analysis-services
reference
dmx

Expressions (DMX)

[!INCLUDEssas]

In Data Mining Extensions (DMX), an expression is a combination of identifiers, values, and operators that [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] can evaluate to obtain a result.

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

Constant
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.

See Also

Data Mining Extensions (DMX) Reference
Data Mining Extensions (DMX) Function Reference
Data Mining Extensions (DMX) Statement Reference
Data Mining Extensions (DMX) Syntax Conventions
Data Mining Extensions (DMX) Syntax Elements
General Prediction Functions (DMX)
Structure and Usage of DMX Prediction Queries
Understanding the DMX Select Statement