data mining lift chart problem on vs2005

Hello . Because of my graduation project , I interested in data mining application , Adventureworks DW on MS VS 2005 . I opened File->Open->project/solution ->Enterprise -> AdventureworksDW .then I successfully deployed the algorithms decision tree and Clustering . Then I opened tab Mining Accuracy Chart then selected input table "testing" , which I had created before , from vTargetMail . After that , mining structure table and target mail table has automaticaly linked each other .Next , I selected predictive input as 1 , of the predictable row "BikeBuyer" . But , when I clicked "Lift Chart ", I only got a 45 degree line , everytime .. How can I fix it ?

It depends - how many rows are in your test set? What do the threes and clusters look like - do they make sense? Maybe there's something wrong with your test data? What shows up in the chart legend - the models you created? What shows up in the floating/docked mining legend when you click on the chart?

I'll need some more information to help you with the issue.

Thanks

-Jamie

|||

I have table LG_131_01 having 2500 rows and I am using algorithms as shown below .

Clustering Algorithm:

Decision Tree Algorithm:

Naive Bayes Algorithm:

and Association Rules Algorithm:

But when I click to "Lift Chart"

I got the following error ..

Failed to execute the query due to the following error:

XML for Analysis parser: The XML for Analysis request timed out before it was completed.
Execution of the managed stored procedure GenerateLiftTableUsingDatasource failed with the following error:

Exception has been thrown by the target of an

invocation.Microsoft::AnalysisServices::AdomdServer::AdomdException.

Please help ..

|||I am still waiting , please help ..|||

The timeout exception issues can be fixed by changing the query execution timeout.

In BI Dev Studio, the Tools menu, select Options, then Business Intelligence Designers. There, change the Query Timeout property. The value should be specified in seconds. A value of 3600 (one hour) should be enough even for the most complex models

Hope this helps

|||

Sir I did your suggestion , it suceed . But now I only got the 45 degree line , comparing Decision trees alg and clustering algorithms . Is it strange ? Why do I get ideal model line like as two algs ? As seen above , testing results were fine .. And I have got table having enough rows of data 2591 rows of data ... Or does the program has a bug ?

|||

The only time I've seen this happen is with using a bad testing set (e.g. using the predicted results as a testing set).

What happens when you use the training set as the testing set? Or try the other form of the lift chart (using a specific state)?