How to: Select Input Tables
Before you create a lift chart in Microsoft SQL Server 2005 Analysis Services (SSAS), you must select the table that contains the data to use to test the accuracy of the mining models. If the data is contained within more than one table, you can add a related nested table to the 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 for the Mining Accuracy Chart.
To select input tables to test the accuracy of a mining model
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 select the table that contains the data that you want to use to determine the accuracy of the models.
In the Select Table dialog box, select a data source from the Data Source list.
In the Table/View Name box, select the table that contains the data you want to use to test the models.
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.
See Also
Other Resources
Mining Accuracy Chart Tab How-to Topics