Manually Edit a Prediction Query

APPLIES TO: yesSQL Server Analysis Services noAzure Analysis Services noPower BI Premium

After you have designed a query by using the Prediction Query Builder, you can modify the query by switching to Query Text view on the Mining Model Prediction tab of Data Mining Designer. A text editor appears at the bottom of the screen to display the query that the query builder created.

Switching to Query Text view is useful for making additions to the query. For example, you can add a WHERE clause or ORDER BY clause.

Use the grid in the Prediction Query Builder to insert the names of objects and columns and set up the syntax for individual prediction functions, and then switch to manual editing mode to change parameter values.


If you switch back to Design view from Query Text view, any changes that you made in Query Text view will be lost.

Modify a query

  1. On the Mining Model Prediction tab in Data Mining Designer in SQL Server Data Tools (SSDT), click SQL.

    The grid at the bottom of the screen is replaced by a text editor that contains the query. You can type changes to the query in this editor.

  2. To run the query, on the Mining Model menu, select Result, or click the button to switch to query results.


    If the query that you have created is invalid, the Results window does not display an error and does not display any results. Click the Design button, or select Design or Query from the Mining Model menu to correct the problem and run the query again.

See Also

Data Mining Queries
Prediction Query Builder (Data Mining)
Lesson 6: Creating and Working with Predictions (Basic Data Mining Tutorial)