SQL Server 2008
Product Build Number
Message Text (original)
Singleton prediction queries against time series models cannot be created by using the query design view on the Mining Model Prediction tab. Instead, type the Data Mining Extensions (DMX) statement directly into the query text view.
This message occurs when all of the following conditions are true:
You are working in Business Intelligence Development Studio, SQL Server Management Studio, or Model Builder.
You are using a PREDICTION JOIN to add new data to an existing time series model.
You are trying to use the query design view to make a singleton prediction against an existing time series model.
You cannot use the query design view to create singleton predictions and simultaneously add new data to a time series model. You can only perform prediction joins against a time series model when you map columns in a new data source against the model.
To create a singleton query against a time series mining model at the same time that you join new data to the model, click SQL, and then type the appropriate DMX statement in the text pane.
For examples of the DMX syntax for creating a singleton query against a time series mining model, see PredictTimeSeries (DMX).