ClusterProbability
Returns the probability that the input case belongs to the specified cluster.
Syntax
ClusterProbability([<Node_Caption>])
Applies To
This function can be used only if the underlying data mining model supports clustering.
Return Type
A scalar value.
Remarks
The following syntax uses the mining model content schema rowset to return the node captions that exist in the mining model.
SELECT NODE_CAPTION FROM <model>.CONTENT
For more information about using this syntax, see SELECT FROM <model>.CONTENT (DMX). For more information about the mining model content schema rowset, see DMSCHEMA_MINING_MODEL_CONTENT Rowset.
If a <node caption> is not specified, the function returns the probability that the input cases belong to the most likely cluster. Use the Cluster function to return the most likely cluster.
Examples
The following example returns the probability that the specified case exists in the cluster labeled Cluster 2.
SELECT
ClusterProbability('Cluster 2')
From
[TM Clustering]
NATURAL PREDICTION JOIN
(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
Reference
Cluster
Data Mining Extensions (DMX) Function Reference
Functions (DMX)
Mapping Functions to Query Types (DMX)