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