TechNet
Export (0) Print
Expand All

PredictAssociation (DMX)

 

Updated: March 2, 2016

Predicts associative membership.

System_CAPS_ICON_note.jpg Note


This is different from creating a prediction on an association model.

  
PredictAssociation(<table column reference>, option1, option2, n ...)  

Classification algorithms and clustering algorithms that contain predictable nested tables. Classification algorithms include the Microsoft Decision Trees, Microsoft Naive Bayes, and Microsoft Neural Network algorithms.

<table expression>

The options for the PredictAssociation function include EXCLUDE_NULL, INCLUDE_NULL, INCLUSIVE, EXCLUSIVE (default), INPUT_ONLY, INCLUDE_STATISTICS, and INCLUDE_NODE_ID.

System_CAPS_ICON_note.jpg Note


INCLUSIVE, EXCLUSIVE, INPUT_ONLY, and INCLUDE_STATISTICS apply only for a table column reference, and EXCLUDE_NULL and INCLUDE_NULL apply only for a scalar column reference.

INCLUDE_STATISTICS only returns $Probability and $AdjustedProbability.

If the numeric parameter n is specified, the PredictAssociation function returns the top n most likely values based on the probability:

PredictAssociation(colref, [$AdjustedProbability], n)  

If you include $AdjustedProbability, the statement returns the top n values based on the $AdjustedProbability.

The following example uses the PredictAssociation function to return the four products in the Adventure Works database that are most likely to be sold together.

SELECT  
  PredictAssociation([Association].[v Assoc Seq Line Items],4)  
From  
  [Association]  

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

Community Additions

ADD
Show:
© 2016 Microsoft