PredictSupport (DMX)

Applies to: SQL Server Analysis Services

Returns the support value for a specified state.


PredictSupport(<scalar column reference>, [<predicted state>])  

Applies To

A scalar column.

Return Type

A scalar value of the type that is specified by <scalar column reference>.


If the predicted state is omitted, the state that has the highest predictable probability is used, excluding the missing states bucket. To include the missing states bucket, set the <predicted state> to INCLUDE_NULL.

To return the support for the missing states, set the <predicted state> to NULL.


The support values are calculated differently or might have a different interpretation depending on the model type that you are querying. For more information about how support is calculated for any particular model type, see the individual algorithm type in Mining Model Content (Analysis Services - Data Mining).


The following example uses a singleton query to predict whether an individual will be a bike buyer, and also determines the support for the prediction based on the TM Decision Tree mining model.

  [Bike Buyer],  
  PredictSupport([Bike Buyer]) AS [Support],  
  [TM Decision Tree]  
(SELECT 28 AS [Age],  
  '2-5 Miles' AS [Commute Distance],  
  'Graduate Degree' AS [Education],  
  0 AS [Number Cars Owned],  
  0 AS [Number Children At Home]) AS t  

See Also

Data Mining Extensions (DMX) Function Reference
Functions (DMX)
General Prediction Functions (DMX)