• Article

Design Pane (Mining Model Prediction View)

The Design pane contains the Prediction Query Builder, which you can use to build data mining predictions. You can design prediction queries that use tables of input data from a data source view, to generate bulk predictions, or you can create singleton prediction queries, which let you provide individual values.

To run the query and view the results, switch to query result view.

The Query view displays the Data Mining Extensions (DMX) query that Prediction Query Builder creates. If you are familiar with DMX, you can customize this query.

Note

If you make any manual changes to the query, your changes will be lost when you switch back to Design view. If you want to save the DMX query, you can copy the query to the Windows Clipboard and then paste it to a text file.

For More Information:Using the Prediction Query Builder to Create DMX Prediction Queries, Querying Data Mining Models (Analysis Services - Data Mining)

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.