views:

12

answers:

0

Hi, I am have two mining models, both are time series. One is [Company_Inputs] and the other is [Booking_Projections].

What I want to do is use EXTEND_MODEL_CASES to join the results of [Company_Inputs] as the extended cases.

So basically something like:

Select Flattened
 PredictTimeSeries([Bookings], 1, 6, EXTEND_MODEL_CASES)
FROM [Booking_Projections]
Natural Prediction Join
        (Select Flattened
                PredictTimeSeries([Metric1], 1, 6)
         From [Company_Inputs]) AS T

This code of course doesn't work, but the idea is to use the predictions made from [Company_Inputs] as cases for predicting future values of [Booking_Projections]

If anyone has an idea of how I can accomplish this I would appreciate it very much.