Design Pane (Mining Model Prediction View)
The Design pane contains the data mining Prediction Query Builder, which you can use to build data mining predictions. You can design prediction queries based on input tables or singleton prediction queries. Switch to the Result view to run the query and view the results. The Query view displays the Data Mining Extensions (DMX) query that Prediction Query Builder creates.
For More Information:Using the Prediction Query Builder to Create DMX Prediction Queries, Singleton Query
Options
- Switch to query result view
Click to switch between the Design, Query, and Result panes. Switching to the Result pane runs the query.
- Save the query result
Opens the Save Data Mining Query Result dialog box.
- Singleton query
Enables creating a singleton query, in which you can provide values directly for the query instead of providing a table as the source of the known data. The Select Input Table(s) table is replaced by a Singleton Query Input table.
- Refresh query results
Reprocesses the prediction query. This is enabled only in the Result pane.
- Mining Model
Displays the selected mining model on which you want to base predictions.
- Select Model
Opens the Select Mining Model dialog box.
- Select Input Table(s)
Displays the selected input tables that contain known data on which to base the predictions.
- Delete Table
Deletes the selected table. This button is disabled if a table has not been selected or does not exist.
- Select Case Table
Opens the Select Table dialog box. This button appears only if a case table has not been selected.
- Select Nested Table
Opens the Select Table dialog box. This button appears only if a case table has been selected. If the associated mining structure does not contain a nested table, this button is disabled.
- Modify Join
Opens the Specify Nested Join dialog box. This button is active only if the nested table is selected.
Singleton Query input
Enabled when you select the Singleton query button. Contains the following columns:Value Description Mining Model Column
Lists the mining model columns contained within the mining model that is selected in the Mining Model table.
Value
Select a value from the list that contains each possible state of the selected mining model column.
If the column is a nested table column, clicking the value cell opens the Nested Table Input dialog box.
Source
Select the source that contains the field that you will use for the column. You can either use the mining model that is selected in the Mining Model table, the input table or tables that are selected in the Select Input Table(s) table, a prediction function, or a custom expression.Columns can be dragged from the tables containing the mining model and input tables onto the cell.
- Field
Select a column from the list of columns derived from the source table. If you selected Prediction Function in Source, this contains the prediction function available for the selected mining model.
- Group
Use with the And/Or column to group expressions together. For example, (expr1 Or expr2) And expr3.
- And/Or
Use to create a logical query. For example, (expr1 Or expr2) And expr3.
- Criteria/Argument
Specify a condition or user expression that applies to the column. Columns can be dragged from the tables containing the mining model and input tables onto the cell.
See Also
Reference
Mining Model Prediction View (Data Mining Model Designer)
Other Resources
Data Mining Extensions (DMX) Statement Reference
Creating DMX Prediction Queries