Drill Through Dialog Box (Mining Model Viewer)


Applies To: SQL Server 2016

When you view a mining model by using the Mining Model Viewer tab of Data Mining Designer, you can drill through into details about the case data, provided the model has drillthrough enabled. Moreover, if the underlying mining structure has drillthrough enabled, you can also see columns in the mining structure, even if those columns were not included in the mining model. In the column list, the structure columns are prefixed by the "Structure." label.

System_CAPS_ICON_note.jpg Note

You cannot enable drillthrough on an existing mining structure. Instead, you must re-create the mining structure and enable drillthrough during the creation process.

For information about how to access case data from each of the mining model viewers that support drillthrough, see Drill Through to Case Data from a Mining Model.

Cases Classified To
Displays the definition of the rule, itemset, and cluster that are contained in the selected node.

Column list
Displays the columns in the model, followed by the structure columns.

Note Structure columns are displayed only if drillthrough is enabled on the mining structure, and if you selected the option, Model and Structure Columns. Moreover, you must have drillthrough permissions on both the mining model and the mining structure to view the columns.

Structure columns that are not included in the model appear as Structure.<column name>.

System_CAPS_ICON_note.jpg Note

You can right-click anywhere in the column grid and select Copy All to copy the drillthrough data, in tab-delimited format, to the Clipboard. The copied data includes only the case data, not the node definition.

Click the green arrow button to refresh the data.

Drillthrough Queries (Data Mining)
Mining Model Viewers (Data Mining Model Designer)
Mining Model Viewer Tasks and How-tos

Community Additions