DMX Analysis Services question

Posted by user282382 on Stack Overflow See other posts from Stack Overflow or by user282382
Published on 2010-05-12T17:21:17Z Indexed on 2010/05/12 17:24 UTC
Read the original article Hit count: 276

Filed under:
|
|
|
|

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.

© Stack Overflow or respective owner

Related posts about data

Related posts about mining