开发者

Microsoft Decision Trees: support cases for a specific node

开发者 https://www.devze.com 2023-03-11 06:59 出处:网络
I\'m using Microsoft Deci开发者_JAVA技巧sion Trees in Microsoft Analysis Services Data Mining, and need to show the historical data (the support cases from the training data used to train the decision

I'm using Microsoft Deci开发者_JAVA技巧sion Trees in Microsoft Analysis Services Data Mining, and need to show the historical data (the support cases from the training data used to train the decision tree) for a given leaf node in my mining model. Is there a way to access those records directly based on the NodeID using a DMX query, or is the only way to get the NODE_DESCRIPTION for the node, replace not = with <> and execute a query against my live database with that as my WHERE clause?


Courtesy of rok1 on the MSDN forums: http://social.msdn.microsoft.com/Forums/en-US/sqldatamining/thread/e6502263-a2b9-4fa1-b60b-04414e3efd29

SELECT * FROM [ModelName].Cases
where ISTrainingCase()
and IsInNode('0') --your intended node 
0

精彩评论

暂无评论...
验证码 换一张
取 消