DMX Analysis Services question
- by user282382
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.