# 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 bottom-most rows, in increasing order of rank based on a rank expression. | |

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. | |

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. | |

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. |

#### Reference

Data Mining Extensions (DMX) Operator ReferenceData 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)