• Article

WarnSingletonInQueryMode

Details

Product Name

SQL Server 2008

Product Version

 10.0.1008.0

Product Build Number

 

Event ID

 

Event Source

Microsoft.AnalysisServices.Controls.ControlsSR

Component

Analysis Services 

Symbolic Name

WarnSingletonInQueryMode

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.

Explanation

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