Using Nested Table Data as an Input for an Accuracy Chart

Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Fabric/Power BI Premium

Important

Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.

When you test the accuracy of a mining model by using external data, if the mining model contains nested tables, the external data must also contain a case table and an associated nested table.

This topic describes how to work with nested tables used for model testing, how to map nested and case tables in the mode and in the external data, and how to apply a filter to a nested table.

When working with nested tables, keep in mind these tips:

  • If you select the option Use mining model test cases or Use mining structure test cases, you do not need to specify a case table or nested table. With those options, the definition of the test data is stored in the mining structure and the test data is automatically selected when you create the accuracy chart.

  • If a relationship already exists between the case and nested table in the data source, the columns in the mining structure are automatically mapped to the columns that have the same name in the input table.

  • You cannot select a nested table until you have specified the case table. Also, you cannot specify a nested table as an input unless the mining model also uses a case table and nested table structure.

Use a nested table as input to an accuracy chart

  1. Double-click the mining structure to open it in Data Mining Designer.

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

  3. In Select data set to be used for accuracy chart, select the option Specify a different data set.

  4. Click the browse button (...) to choose the external data set from a list of data source views on the current server.

  5. Click Select Case Table. In the Select Table dialog box, choose the table from the data source view that contains the case data, and then click OK.

  6. Click Select Nested Table. In the Select Table dialog box, select the table that contains the nested data, and then click OK.

  7. Click OK.

    If you need to modify the relationship between the nested table and the case table, click Modify Join to open the Create Relationship dialog box.

See Also

Choose and Map Model Testing Data
Apply Filters to Model Testing Data