Search code examples
sql-serverssasdata-mining

Querying SQL Sever 2008 clustering datamining model


I know how to get list of clusters and their properties like population and characteristics.

SELECT NODE_NAME, NODE_CAPTION ,NODE_SUPPORT, NODE_DESCRIPTION
FROM TM_Clustering.CONTENT
WHERE NODE_TYPE = 5 AND NODE_SUPPORT > 1000

but I need to get a list of links between these clusters. links are shown in image bellow.

enter image description here


Solution

  • I found the solution :

    CALL System.Microsoft.AnalysisServices.System.DataMining.Clustering.GetNodeGraph('ModelName',0)