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 

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

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

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

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

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

Indicates whether the current node descends from the specified node. 

Indicates whether the specified node contains the case. 

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

Performs a prediction on a specified column. 

Returns the adjusted probability of the specified predictable column. 

Predicts associative membership in a column. 

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

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

Returns the NodeID for a selected case. 

Returns the probability of the specified column. 

Predicts the next values in a sequence. 

Retrieves the standard deviation value for a specified column. 

Returns the support value of the column. 

Predicts the future values for a time series. 

Returns the variance value of the specified column. 

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

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

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

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

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. 

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)