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: 333
        
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