Wednesday, February 15, 2012 3:25 PM
I need some help with DMX, I have req where I need to predict multiple events from a mining model, I started working on getting two predictions, I am geeting the result back but not the format i want
SELECT FLATTENED [Name],
PredictTimeSeries([aging],25) AS r,
PredictTimeSeries([Ext], 25) AS t
Name TIME Aging TIME Ext R03 3/5/2012 0:00 -5.06E+27 R03 3/6/2012 0:00 -1.67E+31 R03 3/5/2012 0:00 51858.10218 R03 3/6/2012 0:00 6901.215308 Name TIME Aging TIME Ext R03 3/5/2012 0:00 -5.06E+27 3/5/2012 0:00 51858.10218 R03 3/6/2012 0:00 -1.67E+31 3/6/2012 0:00 6901.215308
first dataset is what I am getting back when I run the above query, I want my data to be like the second result set.
I have to do the prediction for several columns in the same way.
Thanks in Advance.
- Edited by ramarama Wednesday, February 15, 2012 3:27 PM
Wednesday, February 22, 2012 1:46 AMModerator
As far as i know, there is no straightforward way to format the 2 prediction columns in the same way. If you have to do that, you could consider loading the prediction result into tables of relational database, then join them into one table holding these columns in the same way.
Hope this helpfully,