Data Mining – Mining Model Prediction

Time Series Query

SELECT
([DC Cust Product Model].[DC Cust Product Model]) as [ModelDCCustProduct],
(PredictTimeSeries([DC Cust Product Model].[Revenue],3,18,EXTEND_MODEL_CASES)) as [PredictedRevenue],
PredictTimeSeries([DC Cust Product Model].[Quantity],3,18,EXTEND_MODEL_CASES) as [PredictedQuantity],
(SELECT
$Time,
PredictVariance([Revenue]) AS [VARIANCE_REV],
PredictStdev([Revenue]) AS [STDEV_REV]
FROM
PredictTimeSeries([DC Cust Product Model].[Revenue],3,18,EXTEND_MODEL_CASES) AS t
) AS t
From
[DC Cust Product Model]
PREDICTION JOIN
OPENQUERY([MLMagDW],
‘SELECT
[NumOfWeek],
[ReportingMonth],
[DCCustProductModel],
[Revenue],
[Quantity]
FROM
[dbo].[NewTrainData_DCCustProductModel]
‘) AS t
ON
[DC Cust Product Model].[Num Of Week] = t.[NumOfWeek] AND
[DC Cust Product Model].[Reporting Month] = t.[ReportingMonth] AND
[DC Cust Product Model].[DC Cust Product Model] = t.[DCCustProductModel] AND
[DC Cust Product Model].[Revenue] = t.[Revenue] AND
[DC Cust Product Model].[Quantity] = t.[Quantity]