1

I created a Decision Tree model in Microsoft Analysis Services (SSAS, Visual Studio 2010). There are two tabs in the Mining Model Viewer tab: (1) Decision Tree that shows a tree itself, and (2) Dependency Network that shows the chart of most important variables.

enter image description here

On the Decision Tree tab I can click on each individual leaf and see the English Rule for that leaf. Is there a way to get ALL the rules at once as a list with the case numbers?

The Dependency Network tab has a slider that you can move to see which variables influence the decision tree most. Is it possible to get ALL important variables as a list with their "importance" number?

1 Answer 1

1

I have found a way to get the list of ALL English Rules from the Mining Structure.

SELECT * FROM [MyModel].CONTENT WHERE [CHILDREN_CARDINALITY] = 0

[CHILDREN_CARDINALITY] = 0 defines the DT leaves only.

The following links may be helpful: Decision Trees Model Query Examples, Mining Model Content for Decision Tree Models

"FLATTENED" keyword will split [NODE_DISTRIBUTION] outcomes into separate rows.

SELECT FLATTENED [MODEL_CATALOG],[MODEL_NAME],[NODE_CAPTION],[CHILDREN_CARDINALITY],[NODE_DESCRIPTION],[NODE_PROBABILITY],[NODE_DISTRIBUTION],[NODE_SUPPORT] FROM [MyModel].CONTENT WHERE [CHILDREN_CARDINALITY] = 0 ORDER BY [NODE_SUPPORT] DESC

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.