Mapping Functions to Query Types (DMX)

  • Article

You can use functions to control how queries in Data Mining Extensions (DMX) create predictions in Microsoft SQL Server 2005 Analysis Services (SSAS). However, each query type supports specific functions, and some query types do not support certain functions. For general information about functions in DMX, see Data Mining Extensions (DMX) Function Reference.

You can use the SELECT statement in DMX to create different types of queries. Each query type supports different functions. The following table lists the functions that you can use for each type of SELECT statement.

Query type Supported functions

SELECT DISTINCT FROM <model>

RangeMin, RangeMid, RangeMax

for continuous and discretized columns

SELECT FROM <model>.CONTENT

or

SELECT FROM <model>.DIMENSION_CONTENT

IsDescendent

SELECT FROM <model>.CASES

IsInNode, Lag

SELECT FROM <model>.SAMPLE_CASES

IsInNode

SELECT FROM <model>.PMML

Not applicable.

SELECT FROM <model> PREDICTION JOIN

Prediction functions that are specific to the algorithm that you use to build the model.

SELECT FROM <model>

Prediction functions that are specific to the algorithm that you use to build the model.

For a list of the functions that are supported by Microsoft algorithms, see the individual algorithm topics in Data Mining Algorithms.

You can use the following functions for any SELECT statement that returns a table expression:

  • TopCount
  • BottomCount
  • TopPercent
  • BottomPercent
  • TopSum
  • BottomSum

See Also

Reference

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
Prediction Queries (DMX)
Understanding the Select Statement (DMX)

Help and Information

Getting SQL Server 2005 Assistance