Predicts associative membership.
This is different from creating a prediction on an association model.
The options for the PredictAssociation function include EXCLUDE_NULL, INCLUDE_NULL, INCLUSIVE, EXCLUSIVE (default), INPUT_ONLY, INCLUDE_STATISTICS, and INCLUDE_NODE_ID.
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]