Retrive score in Logistic Regression (Microsoft Neural Net..

Hi!

I bought the book "Data Mining with SQL Server 2005", but I can't find
the solution to a problem I have.

I want to retrieve from C# the logistic regression Attribute Value
(AV) Scores for the Logistic Regression Algorithm. I can see the
Scores from the Microsoft Logistic Regression Viewer (the same of
Neural Network Viewer), but I cannot retrieve them via DMX, OLEDB or
similar.

Otherwise, is there a formula that I can use to compute that score
from the coefficient, support, or probability values of the Attribute
Value pair (I can read this values from DMX)?
I can access to them via DMX:

NODE_DISTRIBUTION -> SUPPORT and PROBABILITY ATTRIBUTE_VALUE...

with a query like

SELECT FLATTENED (SELECT ATTRIBUTE_NAME, ATTRIBUTE_VALUE FROM
NODE_DISTRIBUTION WHERE VALUETYPE = ... ) FROM [MyModel].CONTENT WHERE
NODE_TYPE ....

Thanks in advance

Regards,
Marco

The MS Data Mining team has already prepared additional AS CLR stored
procedure, which does all of this calculations for you. You can freely
download it from SqlServerDataMining.com, if you register on the site.
Besides the procedure you need, you can download also a prepared SSRS
report - scorecard for logistic regression models. The link to the article
is this:
http://www.sqlserverdatamining.com/ssdm/Default.aspx?tabid=102&Id=41. On the
page, you will find the link to download the source code (search for "The
download package is available here and it contains a stored procedure
that:". In the article, you will find detailed instructions how to build and
deploy the procedure.

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx

"Marco__80" <marco.devisio.DeleteThis@gmail.com> wrote in message
news:9b86edac-20df-41ac-9cae-c882a68e6e1f@v3g2000hsc.googlegroups.com...
> Hi!
>
> I bought the book "Data Mining with SQL Server 2005", but I can't find
> the solution to a problem I have.
>
> I want to retrieve from C# the logistic regression Attribute Value
> (AV) Scores for the Logistic Regression Algorithm. I can see the
> Scores from the Microsoft Logistic Regression Viewer (the same of
> Neural Network Viewer), but I cannot retrieve them via DMX, OLEDB or
> similar.
>
> Otherwise, is there a formula that I can use to compute that score
> from the coefficient, support, or probability values of the Attribute
> Value pair (I can read this values from DMX)?
> I can access to them via DMX:
>
> NODE_DISTRIBUTION -> SUPPORT and PROBABILITY ATTRIBUTE_VALUE...
>
> with a query like
>
> SELECT FLATTENED (SELECT ATTRIBUTE_NAME, ATTRIBUTE_VALUE FROM
> NODE_DISTRIBUTION WHERE VALUETYPE = ... ) FROM [MyModel].CONTENT WHERE
> NODE_TYPE ....
>
> Thanks in advance
>
> Regards,
> Marco