'Decision Trees found no appropriate regressors for model' question

Hi,

I am using MS Decision Trees algorithm and for a specific model i get the above warning.As a result of that i dont get any splits in my tree. Is there anything i can do to avoid this?

Thank you for reading

Actually, the regressors will not be used in finding splits, but as arguments to the regression formulae in each node.

There are a few things you can try:

- make sure that all the continuous input columns in the model have the REGRESSOR modeling flag. This should happen automatically if you use BI Developer Studio, but that may not be the case if the model is created using DMX scripts

- If a continuous column should be, based on your knowledge of the data, a regressor, but it is not selected by the algorithm, you can 'force' this to happen by specifying the column name as the value of the FORCE_REGRESSOR parameter of the algorithm

Decision tree in MS SQL Server

Hi,

Can we represent the Decision Tree in a programatically way in an .NET application? I understand that the outcome of a Decision Tree model can be integrated into an .NET application but not sure if we can also visualize it. Does MS SQL Server support any API to render such a tree?

Thanks a lot!

In a WinForm application, you could embed the viewer control (the same control used in BI Developer studio to render decision trees). A sample for this is available on our site, sqlserverdatamining.com. The direct link is http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=1362 and requires creating a free account.

SQL Server also includes (in the Analysis Services samples) the complete source code for a set of web viewer controls which work for a few algorithms, including Decision Trees rendering. The sample is called Data Mining Web Controls

Hope this helps

|||Thank you.

Decision tree in MS SQL Server

Hi,

Can we represent the Decision Tree in a programatically way in an .NET application? I understand that the outcome of a Decision Tree model can be integrated into an .NET application but not sure if we can also visualize it. Does MS SQL Server support any API to render such a tree?

Thanks a lot!

In a WinForm application, you could embed the viewer control (the same control used in BI Developer studio to render decision trees). A sample for this is available on our site, sqlserverdatamining.com. The direct link is http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=1362 and requires creating a free account.

SQL Server also includes (in the Analysis Services samples) the complete source code for a set of web viewer controls which work for a few algorithms, including Decision Trees rendering. The sample is called Data Mining Web Controls

Hope this helps

|||Thank you.