none
One Key TIme Column must be defined

    Question

  • Hello,

    I am having a very difficult time getting a basic data mining project to work and I am fairly certain it is a small mistake.

    I am trying to use Time Series to Predict the future hours flown for a fleet of aircraft. Below ids the query to create my view and a small data sample returned.

    SELECT        TOP (100) PERCENT ah.MODEL, DATEPART(yyyy, fl.ACTUAL_DEPARTING_DATE) * 100 + DATEPART(mm, fl.ACTUAL_DEPARTING_DATE) AS TimeIndex,    SUM(fl.ACTUAL_HOURS) AS Hours, ae.EXTENDED_FIELD6 AS [FM Planner], ae.EXTENDED_FIELD1 AS ARO, fl.ACTUAL_DEPARTING_DATE AS FltDate

    FROM            dbo.AIRCRAFT_HDR AS ah LEFT OUTER JOIN dbo.FLIGHT_LOG AS fl ON ah.DOC_NO = fl.AIRCRAFT_DOC_NO LEFT OUTER JOIN dbo.AIRCRAFT_EXT AS ae ON ah.DOC_NO = ae.DOC_NO

    GROUP BY ah.MODEL, DATEPART(yyyy, fl.ACTUAL_DEPARTING_DATE) * 100 + DATEPART(mm, fl.ACTUAL_DEPARTING_DATE), ae.EXTENDED_FIELD6, ae.EXTENDED_FIELD1,    fl.ACTUAL_DEPARTING_DATE

    HAVING        (NOT (ah.MODEL = '141'))

    ORDER BY ah.MODEL

    Model

    TimeIndex

     

    Hours

    FM Planner

    ARO

    FltDate

    206H           

    200805

     

    4.20

    John

    SEARO

    2008-05-13 03:00:00.000

    206H           

    200805

     

    1.60

    John

    SEARO

    2008-05-27 01:00:00.000

    206H           

    200805

     

    1.70

    Josh

    TNG

    2008-05-26 01:00:00.000

    206H           

    200806

     

    6.00

    James

    WARO

    2008-06-12 01:00:00.000

    206H           

    200806

     

    3.50

    John

    SEARO

    2008-06-18 01:00:00.000

    206H           

    200807

     

    1.50

    John

    NEARO

    2008-07-24 01:00:00.000

    206H           

    200807

     

    1.50

    John

    SEARO

    2008-07-09 01:00:00.000

     

    When I Add this as a DSV I select the FltDate as the Key Time Column, Model as a Key Column and Hours as the PredictOnly Column but receive this error when I attempt to process the Model.

    Error (Data mining): A time series structure was defined without a Key Time column. One Key Time column must be defined.

    I have worked through the tutorial several times with complete success and have looked carefully at the process and tried to emulate it as closely as possible.

    What am I missing?

     

    Thank You for any assistance you can provide.

    J.B.


    Wednesday, November 13, 2013 4:06 PM

All replies

  • Hi

    Looking at your source data,

    1. FltDate is not in continuous form. Time series requires continuous Time Key with Sort Order.

    2. Model should have TEXT KEY defined at structure

    Please provide your ordered sample data set for better understanding


    Prav

    Friday, November 15, 2013 5:28 AM