Getting the Model's (Decision tree) PMML

Hi

Can anyone tell me the steps involved in retrieving a model's (decision tree) pmml and use the model content to devleop a web based interface. I am using SQL Server 2005.

Thanks,

Nathan

To get the PMML is relatively easy. Just execute a query like:

SELECT MODEL_PMML FROM <model>.PMML

This query will return the PMML rendering of the model content, as long as:

- the model contains a single predictable variable (asingle tree)

- the model does not include a date time column

Both these limitations derived from limitations of the PMML 2.1 standard which is supported by Analysis Services 2005.

Now, to use the content for a web interface -- not sure whether PMML is the best path. You can, of course, traverse the PMML using an XML reader and render the content in any form you like. You can do the same thing and get rid of the limitations above by issuing content queries against Analysis Services

E.g. SELECT * FROM <model>.CONTENT

Also, SQL Server 2005 provides a sample called Data mining Web Controls which include a web rendering for decision trees (again, without the limitations above). The sample includes source code.

You can try the sample at this location: http://www.sqlserverdatamining.com/MovieSurveyDemo

Just expand the Forests node and click on a tree (say, Demographic Forest)

|||You had mentioned that the sample includes source code...but I did not find any...can you tell me specifically where it is...|||

The source code is included in the samples coming with SQL Server.

It was also recently uploaded on the web at http://www.codeplex.com/MSFTASProdSamples/Wiki/View.aspx?title=SS2005%21Data%20Mining%20Web%20Controls%20Library&referringTitle=Home