DMX Help

Question

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

FROM [Symm]

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.

Answer 1

Hi rama,

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,

Regards,
Jerry