Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic


Product Name

SQL Server 2008

Product Version


Product Build Number


Event ID


Event Source



Analysis Services 

Symbolic Name


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).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.