Creating Time Series Mining Structure with DMX

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply