Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error Time Series algorithm Expand / Collapse
Author
Message
Posted Monday, February 03, 2014 12:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 12:15 PM
Points: 2, Visits: 7
I'm doing the tutorial from msdn for Serial Time algorithm. To process it I get the following error:

Error 1 Error (Data mining): Usage of all non-key columns in the 'Forecasting' mining model must be set to PredictOnly.


Someone may guide me. thanks
Post #1537459
Posted Monday, February 03, 2014 4:06 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:39 AM
Points: 2,728, Visits: 2,640
You probably have NULL/missing values for the algorithm.
Go to the tab Mining models, right click on the model and choose "Set Algorithm parameters ...". Find the parameter MISSING_VALUE_SUBSTITUTION and type "Mean" in the Value column.

Regards,
Igor
Post #1537547
Posted Monday, February 03, 2014 8:26 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 25, 2014 12:15 PM
Points: 2, Visits: 7
Igor, thanks for your response. The MISSING_VALUE_SUBSTITUTION value was already set that way "Mean". Any more help?
Thank you
Cesar
Post #1537596
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse