data-mining-extensions-dmx-function-reference.md

title	Data Mining Extensions (DMX) Function Reference | Microsoft Docs
ms.custom
ms.date	03/02/2016
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services analysis-services/data-mining
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	DMX
helpviewer_keywords	DMX [Analysis Services], functions functions [DMX] Data Mining Extensions [Analysis Services], functions
ms.assetid	fadd105b-9c8e-4118-a1f7-c0518b9ad970
caps.latest.revision	35
author	Minewiskan
ms.author	owend
manager	erikre

Data Mining Extensions (DMX) Function Reference

[!INCLUDEtsql-appliesto-ss2008-all_md]

[!INCLUDEssASnoversion] 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 provides links to resources to help you understand how to use functions in DMX.

Function	Description
General Prediction Functions (DMX)	List functions that can be used with all model types, and provides links to more information about how to query specific types of mining models.
Structure and Usage of DMX Prediction Queries	Provides an overview of how to construct a prediction query by using DMX.
BottomCount (DMX)	Returns a table that contains a specified number of bottom-most rows, in increasing order of rank based on a rank expression.

The following table lists the functions that DMX supports.

Function	Description
BottomCount (DMX)	Returns a table that contains the last n-item rows of the table expression, in increasing order based on a rank expression.
BottomPercent (DMX)	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 (DMX)	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 (DMX)	Returns the cluster that is most likely to contain the input case.
ClusterProbability (DMX)	Returns the probability that the input case belongs to the cluster.
Exists (DMX)	Returns true if the result set returned by the specified SELECT statement contains at least one row.
IsDescendant (DMX)	Indicates whether the current node descends from the specified node.
IsInNode (DMX)	Indicates whether the specified node contains the case.
IsTestCase (DMX)	Indicates whether a case belongs to the set of test cases.
IsTrainingCase (DMX)	Indicates whether a case belongs to the set of training cases.
Lag (DMX)	Returns the time slice between the date of the current case and the last date in the data.
Predict (DMX)	Performs a prediction on a specified column.
PredictAdjustedProbability (DMX)	Returns the adjusted probability of the specified predictable column.
PredictAssociation (DMX)	Predicts associative membership in a column.
PredictCaseLikelihood (DMX)	Returns the likelihood that an input case will fit within the existing model. This function can only be used with clustering models.
PredictHistogram (DMX)	Returns a table that represents the histogram for a specified column.
PredictNodeId (DMX)	Returns the NodeID for a selected case.
PredictProbability (DMX)	Returns the probability of the specified column.
PredictSequence (DMX)	Predicts the next values in a sequence.
PredictStdev (DMX)	Retrieves the standard deviation value for a specified column.
PredictSupport (DMX)	Returns the support value of the column.
PredictTimeSeries (DMX)	Predicts the future values for a time series.
PredictVariance (DMX)	Returns the variance value of the specified column.
RangeMax (DMX)	Returns the upper value of the predicted bucket that is discovered for a specified discretized column.
RangeMid (DMX)	Returns the midpoint value of the predicted bucket that is discovered for a specified discretized column.
RangeMin (DMX)	Returns the lower value of the predicted bucket that is discovered for a specified discretized column.
StructureColumn (DMX)	Returns the value of the specified table mining structure column.
TopCount (DMX)	Returns a table that contains a specified number of topmost rows, in a decreasing order of rank based on a rank expression.
TopPercent (DMX)	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 (DMX)	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

Data Mining Extensions (DMX) Operator Reference
Data Mining Extensions (DMX) Statement Reference
Data Mining Extensions (DMX) Syntax Conventions
Data Mining Extensions (DMX) Syntax Elements
General Prediction Functions (DMX)
Structure and Usage of DMX Prediction Queries
Understanding the DMX Select Statement