• Article

How to: Filter the Input Rows for an Accuracy Chart

In Business Intelligence Development Studio, you can specify an external data source to use in testing a model, and optionally add filters to restrict the input data. For example, if you want to limit the input to customers in the ProspectiveBuyer table who are in a specific income group, you could create the filter expression, [YearlyIncome] = '50000'.

For more information, see Tools for Charting Model Accuracy (Analysis Services - Data Mining).

To apply a filter to an external data set

  1. Double-click the mining structure that contains the model you want to test, to open the structure and its models in Data Mining Designer.

  2. Select the Mining Accuracy Chart tab, and then select the Input Selection tab.

  3. On the Input Selection tab, under Select data set to be used for Accuracy Chart, select the option Specify a different data set.

  4. Click the browse button (…) to open a dialog box and build the definition of the external data set

  5. Choose the case table, add a nested table if necessary, and change the mapping of columns if necessary. For more information, see the following topics:

  6. To close the Specify Column Mapping dialog box and save the source table definition, Click OK.

  7. Click Open Filter Editor to define a filter for the data set.

    The Data Set Filter dialog box opens. If the structure contains a nested table, you can create a filter in two parts. First, set conditions on the case table by using the Data Set Filter dialog box, and then set conditions on the nested rows by using the Filter dialog box.

  8. In the Data Set Filter dialog box, click the top row in the grid, under Mining Structure Column, and select a table or column from the list.

    If the data source view contains multiple tables, or a nested table, you must first select the table name. Otherwise, you can select columns from the case table directly.

    Add a new row for each column that you want to filter.

  9. Use Operator, and Value columns to define how the column is filtered.

    Note   Type values without using quotation marks.

  10. Click the And/Or text box and select a logical operator to define how multiple conditions are combine.

  11. Optionally, click the browse button (…) at the right of the Value text box to open the Filter dialog box and set conditions on the nested table or on the individual case table columns.

  12. Verify that the completed filter conditions are correct by viewing the text in the Expression pane.

  13. Click OK. 

    The filter condition is applied to the data source when you create the accuracy chart.