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

Creating Time Series Mining Structure with DMX Expand / Collapse
Author
Message
Posted Thursday, May 09, 2013 8:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:57 AM
Points: 2, Visits: 23
Hi.
I´m trying to create a mining structure with the next dmx code:
CREATE MINING MODEL [Cassandra]
(
[CompanyNK] TEXT KEY,
[Date] Date KEY TIME,
[Total Value Mes] Double Continuous Predict,
[New Items Month] Long Continuous,
[Number Branches] Long Continuous,
[Number Clients] Long Continuous,
[Number Salesman] Long Continuous

)
USING Microsoft_Time_Series(AUTO_DETECT_PERIODICITY = 0.8, FORECAST_METHOD = 'MIXED')
WITH DRILLTHROUGH

And i get the following error: Error (Data mining): Usage of all non-key columns in the 'Cassandra' mining model must be set to PredictOnly.

This works because i already used this structure in SSDT, and it worked without having anything as predict only.

Can someone help?
Thanks in advance
Post #1451151
Posted Monday, May 13, 2013 2:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:57 AM
Points: 2, Visits: 23
Ok... I don't know what the problem was. But shutting-down the computer for all the weekend appeared to solve the problem. I didn't do anything despite of turning the computer on and compile, and it worked.

Best Regards, Helder Borges
Post #1451996
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse