Data Mining Extensions (DMX) Function Reference

Analysis Services supports several functions in the Data Mining Extensions (DMX) language. Functions expand the results of a prediction query to include information that further describes the prediction. Functions also provide more control over how the results of the prediction are returned. The following table lists the functions that DMX supports.

Function Description

BottomCount

Returns a table that contains a specified number of bottom-most rows, in increasing order of rank based on a rank expression.

BottomPercent

Returns a table that contains the smallest number of bottom-most rows that meet a specified percent expression, in increasing order of rank based on a rank expression.

BottomSum

Returns a table that contains the smallest number of bottom-most rows that meet a specified sum expression, in increasing order of rank based on a rank expression.

Cluster

Returns the cluster that is most likely to contain the input case.

ClusterProbability

Returns the probability that the input case belongs to the cluster.

IsDescendant

Indicates whether the current node descends from the specified node.

IsInNode

Indicates whether the specified node contains the case.

Lag

Returns the time slice between the date of the current case and the last date in the data.

Predict

Performs a prediction on a specified column.

PredictAdjustedProbability

Returns the adjusted probability of the specified predictable column.

PredictAssociation

Predicts associative membership in a column.

PredictCaseLikelihood

Returns the likelihood that an input case will fit within the existing model. This function can only be used with clustering models.

PredictHistogram

Returns a table that represents the histogram for a specified column.

PredictNodeId

Returns the NodeID for a selected case.

PredictProbability

Returns the probability of the specified column.

PredictSequence

Predicts the next values in a sequence.

PredictStdev

Retrieves the standard deviation value for a specified column.

PredictSupport

Returns the support value of the column.

PredictTimeSeries

Predicts the future values for a time series.

PredictVariance

Returns the variance value of the specified column.

RangeMax

Returns the upper value of the predicted bucket that is discovered for a specified discretized column.

RangeMid

Returns the midpoint value of the predicted bucket that is discovered for a specified discretized column.

RangeMin

Returns the lower value of the predicted bucket that is discovered for a specified discretized column.

TopCount

Returns a table that contains a specified number of topmost rows, in a decreasing order of rank based on a rank expression.

TopPercent

Returns a table that contains the smallest number of topmost rows that meet a specified percent expression, in a decreasing order of rank based on a rank expression.

TopSum

Returns a table that contains the smallest number of topmost rows that meet a specified sum expression, in a decreasing order of rank based on a rank expression.

See Also

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
Mapping Functions to Query Types (DMX)
Prediction Queries (DMX)
Understanding the Select Statement (DMX)

Help and Information

Getting SQL Server 2005 Assistance