is this possible to creating credit scoring project with ssas 2008

Hi,

we want to create credir scoring project i want to know is this possible
with microsoft bi?

thanks .

> we want to create credir scoring project i want to know is this possible
> with microsoft bi?

Yes, you can use Data Mining in SSAS 2008 for this purpose. There are many
useful algorithms for this task, e.g. Neural Networks, Logistic Regression,
Decision Trees...

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

hi Dejan,

A scorecard for Logistic Regression models exercise is ansering to my
question exactlly but when i try to do this exercise with my own table i am
getting an error on management studio side
"Executing the query ...
Execution of the managed stored procedure ScoreCard failed with the
following error: Exception has been thrown by the target of an invocation.The
mining model content seems to be corrupted. If reprocessing the model does
not solve the problem try to get an update for this stored procedure.

Execution complete"

if you want to see my data i could send you as soon as possible

my mining model is logistic regretion
and i builded the logreghalper like the exercise

firts 3 fınction in logreghelper is working succesfully with my data
and scorecard and simplescorecard functions is not working

thanks

Serkan.

Did you reporcess the model?
BTW, I've seen errors in AS stored procedures before SP2. Do you have SP2?

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

"skeskin" wrote in message
news:17BF011F-7EBB-4BB0-9C59-27CEB061B8E1-at-microsoft.com...
> hi Dejan,
>
> A scorecard for Logistic Regression models exercise is ansering to my
> question exactlly but when i try to do this exercise with my own table i
> am
> getting an error on management studio side
> "Executing the query ...
> Execution of the managed stored procedure ScoreCard failed with the
> following error: Exception has been thrown by the target of an
> invocation.The
> mining model content seems to be corrupted. If reprocessing the model does
> not solve the problem try to get an update for this stored procedure.
>
> Execution complete"
>
> if you want to see my data i could send you as soon as possible
>
> my mining model is logistic regretion
> and i builded the logreghalper like the exercise
>
> firts 3 fınction in logreghelper is working succesfully with my data
> and scorecard and simplescorecard functions is not working
>
> thanks
>
> Serkan.

Hi Dejan,

Yes i reprocessed the mining model more than ones.
my sql server ssas is not 2005 version


Microsoft Visual Studio 2008
Version 9.0.30428.1 SP1Beta1
Microsoft .NET Framework
Version 3.5 SP1

Installed Edition: IDE Standard

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
(KB945282) KB945282
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be
uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/945282.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
(KB946040) KB946040
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be
uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946040.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
(KB946308) KB946308
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be
uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946308.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
(KB946344) KB946344
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be
uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946344.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
(KB946581) KB946581
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be
uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/946581.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
(KB947173) KB947173
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be
uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947173.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
(KB947540) KB947540
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be
uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947540.

Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
(KB947789) KB947789
This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU.
If you later install a more recent service pack, this hotfix will be
uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/947789.

SQL Server Analysis Services
Microsoft SQL Server Analysis Services Designer
Version 10.0.1442.32

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 10.0.1442.32 ((SQL_PreRelease).080529-2343 )

SQL Server Reporting Services
Microsoft SQL Server Reporting Services Designers
Version 10.0.1442.32


Microsoft SQL Server Management Studio Complete (expires in 161
days) 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
Microsoft Analysis Services Client Tools 2007.0100.1442.032
((SQL_PreRelease).080529-2343 )
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.3031
Operating System 5.1.2600


i succesfully executing the procedures with "college plans" mining model bur
my mining model "v credit" is working first 3 procedures but not working with
scorecard and simplescorecard procedures i think that the problem related to
my data set or procedure

thanks for your interest

Serkan.

"Dejan Sarka" wrote:

> Did you reporcess the model?
> BTW, I've seen errors in AS stored procedures before SP2. Do you have SP2?
>
> --
> Dejan Sarka
> http://blogs.solidq.com/EN/dsarka/default.aspx
>
> "skeskin" wrote in message
> news:17BF011F-7EBB-4BB0-9C59-27CEB061B8E1-at-microsoft.com...
> > hi Dejan,
> >
> > A scorecard for Logistic Regression models exercise is ansering to my
> > question exactlly but when i try to do this exercise with my own table i
> > am
> > getting an error on management studio side
> > "Executing the query ...
> > Execution of the managed stored procedure ScoreCard failed with the
> > following error: Exception has been thrown by the target of an
> > invocation.The
> > mining model content seems to be corrupted. If reprocessing the model does
> > not solve the problem try to get an update for this stored procedure.
> >
> > Execution complete"
> >
> > if you want to see my data i could send you as soon as possible
> >
> > my mining model is logistic regretion
> > and i builded the logreghalper like the exercise
> >
> > firts 3 fınction in logreghelper is working succesfully with my data
> > and scorecard and simplescorecard functions is not working
> >
> > thanks
> >
> > Serkan.
>
>

I think you have SQL Server 2008 RC) and Visual Studio 2008 SP1 Beta. The
final versions are out, and there is no support for beta versions.
Therefore, I suggest you install SQL 2008 RTM and VS 2008 SP1. Do please
mind the intallation order - check this blog:
http://blogs.msdn.com/psssql/archive...explained.aspx.

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

"skeskin" wrote in message
news:9E853873-E717-4C11-BE70-C3F244616314-at-microsoft.com...
> Hi Dejan,
>
> Yes i reprocessed the mining model more than ones.
> my sql server ssas is not 2005 version
>
>
> Microsoft Visual Studio 2008
> Version 9.0.30428.1 SP1Beta1
> Microsoft .NET Framework
> Version 3.5 SP1
>
> Installed Edition: IDE Standard
>
> Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
> (KB945282) KB945282
> This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) -
> ENU.
> If you later install a more recent service pack, this hotfix will be
> uninstalled automatically.
> For more information, visit http://support.microsoft.com/kb/945282.
>
> Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
> (KB946040) KB946040
> This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) -
> ENU.
> If you later install a more recent service pack, this hotfix will be
> uninstalled automatically.
> For more information, visit http://support.microsoft.com/kb/946040.
>
> Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
> (KB946308) KB946308
> This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) -
> ENU.
> If you later install a more recent service pack, this hotfix will be
> uninstalled automatically.
> For more information, visit http://support.microsoft.com/kb/946308.
>
> Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
> (KB946344) KB946344
> This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) -
> ENU.
> If you later install a more recent service pack, this hotfix will be
> uninstalled automatically.
> For more information, visit http://support.microsoft.com/kb/946344.
>
> Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
> (KB946581) KB946581
> This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) -
> ENU.
> If you later install a more recent service pack, this hotfix will be
> uninstalled automatically.
> For more information, visit http://support.microsoft.com/kb/946581.
>
> Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
> (KB947173) KB947173
> This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) -
> ENU.
> If you later install a more recent service pack, this hotfix will be
> uninstalled automatically.
> For more information, visit http://support.microsoft.com/kb/947173.
>
> Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
> (KB947540) KB947540
> This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) -
> ENU.
> If you later install a more recent service pack, this hotfix will be
> uninstalled automatically.
> For more information, visit http://support.microsoft.com/kb/947540.
>
> Hotfix for Microsoft Visual Studio 2008 Shell (integrated mode) - ENU
> (KB947789) KB947789
> This hotfix is for Microsoft Visual Studio 2008 Shell (integrated mode) -
> ENU.
> If you later install a more recent service pack, this hotfix will be
> uninstalled automatically.
> For more information, visit http://support.microsoft.com/kb/947789.
>
> SQL Server Analysis Services
> Microsoft SQL Server Analysis Services Designer
> Version 10.0.1442.32
>
> SQL Server Integration Services
> Microsoft SQL Server Integration Services Designer
> Version 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
>
> SQL Server Reporting Services
> Microsoft SQL Server Reporting Services Designers
> Version 10.0.1442.32
>
>
> Microsoft SQL Server Management Studio Complete (expires in 161
> days) 10.0.1442.32 ((SQL_PreRelease).080529-2343 )
> Microsoft Analysis Services Client Tools 2007.0100.1442.032
> ((SQL_PreRelease).080529-2343 )
> Microsoft Data Access Components (MDAC) 2000.085.1117.00
> (xpsp_sp2_rtm.040803-2158)
> Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
> Microsoft Internet Explorer 6.0.2900.2180
> Microsoft .NET Framework 2.0.50727.3031
> Operating System 5.1.2600
>
>
> i succesfully executing the procedures with "college plans" mining model
> bur
> my mining model "v credit" is working first 3 procedures but not working
> with
> scorecard and simplescorecard procedures i think that the problem related
> to
> my data set or procedure
>
> thanks for your interest
>
> Serkan.
>
> "Dejan Sarka" wrote:
>
>> Did you reporcess the model?
>> BTW, I've seen errors in AS stored procedures before SP2. Do you have
>> SP2?
>>
>> --
>> Dejan Sarka
>> http://blogs.solidq.com/EN/dsarka/default.aspx
>>
>> "skeskin" wrote in message
>> news:17BF011F-7EBB-4BB0-9C59-27CEB061B8E1-at-microsoft.com...
>> > hi Dejan,
>> >
>> > A scorecard for Logistic Regression models exercise is ansering to my
>> > question exactlly but when i try to do this exercise with my own table
>> > i
>> > am
>> > getting an error on management studio side
>> > "Executing the query ...
>> > Execution of the managed stored procedure ScoreCard failed with the
>> > following error: Exception has been thrown by the target of an
>> > invocation.The
>> > mining model content seems to be corrupted. If reprocessing the model
>> > does
>> > not solve the problem try to get an update for this stored procedure.
>> >
>> > Execution complete"
>> >
>> > if you want to see my data i could send you as soon as possible
>> >
>> > my mining model is logistic regretion
>> > and i builded the logreghalper like the exercise
>> >
>> > firts 3 fınction in logreghelper is working succesfully with my data
>> > and scorecard and simplescorecard functions is not working
>> >
>> > thanks
>> >
>> > Serkan.
>>
>>