Share via


How to: Select Input Tables for a Prediction Query

Before you can create a prediction query in Microsoft SQL Server Analysis Services, you must select the table that contains the data on which to base the query. If the data is contained within more than one table, you can add a related nested table to the Select Input Table(s) table of the Mining Accuracy Chart tab of Data Mining Designer, by using the Select Nested Table button. For more information about how to add a nested table, see How to: Add a Nested Table to the Input Tables of a Prediction Query.

To select an input table

  1. On the Select Input Table(s) table of the Mining Accuracy Chart tab in Data Mining Designer in Business Intelligence Development Studio, click Select Case Table.

    The Select Table dialog box opens, in which you can select the table that contains the data on which to base your queries.

  2. In the Select Table dialog box, select a data source from the Data Source list.

  3. Under Table/View Name, select the table that contains the data you want to use to test the models.

  4. Click OK.

    The columns in the mining structure are automatically mapped to the columns that have the same name in the input table. To delete a mapping, click to select the line that links the column in the Mining Structure table to the mapped column in the Select Input Table(s) table, and then press DELETE. You can also manually create mappings by clicking a column in the Select Input Table(s) table and dragging it to the corresponding column in the Mining Structure table.