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
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.
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
- Proposed as answer by Mike YinMicrosoft contingent staff, Moderator Friday, November 29, 2013 2:55 PM