Data Types (DMX)

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

When you use Data Mining Extensions (DMX) to define a new mining model in Microsoft SQL Server Analysis Services, you must provide a data type for each column in the model. The data type describes the data that the data mining algorithm will use when it builds the model.

Data types depend on the algorithm. Each algorithm determines which data types are supported and how they are used. Microsoft algorithms support the following data types:

  • Text

  • Long

  • Boolean

  • Double

  • Date

    For more information about the data types that Analysis Services supports, see Data Types (Data Mining).

See Also

Data Mining Algorithms (Analysis Services - Data Mining)
Data Mining Extensions (DMX) Reference
Data Mining Extensions (DMX) Function Reference
Data Mining Extensions (DMX) Operator 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