#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0

    Question DMX Creating a mining structure with dmx


    Hi guys.
    Im using MS Sql management studio to create a Time Series Data Mining Structure.
    Im using the following code:

    Code:
      CREATE MINING MODEL [Forecasting_MIXED]
         (
        [Reporting Date] DATE KEY TIME,
        [Model Region] TEXT KEY,
        [Quantity] LONG CONTINUOUS PREDICT,
        [Amount] DOUBLE CONTINUOUS PREDICT
        )
    USING Microsoft_Time_Series (AUTO_DETECT_PERIODICITY = 0.8, FORECAST_METHOD = 'MIXED')
    WITH DRILLTHROUGH
    But im always getting this error:

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

    Can someone help me to fix it?

    Thanks in advance
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2013
    Posts
    2
    Rep Power
    0
    Originally Posted by Helder
    Hi guys.
    Im using MS Sql management studio to create a Time Series Data Mining Structure.
    Im using the following code:

    Code:
      CREATE MINING MODEL [Forecasting_MIXED]
         (
        [Reporting Date] DATE KEY TIME,
        [Model Region] TEXT KEY,
        [Quantity] LONG CONTINUOUS PREDICT,
        [Amount] DOUBLE CONTINUOUS PREDICT
        )
    USING Microsoft_Time_Series (AUTO_DETECT_PERIODICITY = 0.8, FORECAST_METHOD = 'MIXED')
    WITH DRILLTHROUGH
    But im always getting this error:

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

    Can someone help me to fix it?

    Thanks in advance
    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

IMN logo majestic logo threadwatch logo seochat tools logo