PredictTimeSeries Error

Question

I get the following error when using the PredictTimeSeries function.

Executing the query ...

Error (Data mining): The PREDICTTIMESERIES function cannot be used in the context at line 2, column 1.

Execution complete

---

Chad E. Downey, MIT, CDMP

Answer 1

Hi Chad,

From the error message, we couldn't find the root cause. Here is an example of using predicttimeseries in DMX query -

SELECT FLATTENED
             [Forecasting].[Model Region], PredictTimeSeries([Forecasting].[Quantity],3) AS t
From
          [Forecasting]
Where [Model Region] = 'M200 Europe'

For more information about its syntax and examples, see http://technet.microsoft.com/en-us/library/ms132167(SQL.100).aspx . If the issue couldn't still be solved by the above reference, please post the entire query here for further analysis.

Regards,
Jerry

Answer 2

Chad,

Please check that you are trying to call the function on time series model. You get this error if model is not using Microsoft Time Series algorithm.

---

Tatyana Yakushev [PredixionSoftware.com]