Prediction Query Builder

Analysis Services

Analysis Services

Prediction Query Builder

Use this tool to create prediction query syntax for a Data Mining Prediction Query task that conforms to the OLE DB for Data Mining specification.

This dialog box is displayed when you click New Query on the Query tab of the Data Mining Prediction Query Task dialog box.

Options

Case table

Select the source table that contains the cases to be analyzed for the prediction query.

Browse

Click to view a sample of data from the source table.

Input columns

Clear the check box next to the name of an input column other than the case key column to remove it from the prediction query. The case key column is used to uniquely identify records in the results of the prediction query.

Note  Excluding columns from Input columns may affect the values of the predicted column in the output table the task produces.

Name

View the names of input columns from the source table that are available to be included in the prediction query.

Source Column

View the names of input columns selected to be included in the prediction query.

Predicted column

Select a predicted column from the list of available prediction columns. The definition of the data mining model used in the data mining prediction query task determines which columns are available.

See Also

Data Mining Prediction Query Task Dialog Box

Predictions and Results of Data Mining