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