Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Problems with Data Mining Prediction

Author  Topic  CWoo Starting Member 2 Posts Posted - 2004-01-26 : 20:46:56 Scenario: I have created a decision tree mining model and processed it with some training data in Analysis Services. I then used it to get some predicted values using some fresh new data. I went into Enterprise Manager DTS and created a new task. I set up a Data Mining Prediction Task by first selecting the mining model that I created, then writing a prediction query in the Query Tab, and finally setting an output table for the prediction results. Question 1: When I ran the task, it worked. But when I viewed the results, the prediction column contained all zero's. Why? Question 2: I went back to my Data Mining Prediction Task and edited the prediction query by adding an extra prediction column called PredictScore(). But when I ran the task again this time, the task failed. The error message I got was "The operation has failed because of an error in the COM component (Microsoft OLE DB Provider for Data Mining Services) Reference column 'PredictScore' does not exist within the current context". Does anyone know what is going on? What is the difference between Analysis Services and OLE DB for Data Mining specification? I am totally new at this, so any help would be greatly appreciated. Thanks CW