Drill Through to Case Data from a Mining Model
Applies To: SQL Server 2016
If a mining model has been configured to let you drill through to model cases, when you browse the model, you can retrieve detailed information about the cases that were used to create the model. Moreover, if the underlying mining structure has been configured to allow drillthrough to structure cases, and you have the appropriate permissions, you can return information from the mining structure. This can include columns that were not included in the mining model.
If the mining structure does not allow you to drill through to the underlying data, but the mining model does, you can view information from the model cases, but not from the mining structure.
Depending on the type of viewer you are using, you can select the node for drillthrough in the following ways:
|Viewer name||Pane or tab name||Select node|
|Microsoft Tree Viewer||Decision Tree tab||Click a tree node.|
Note Avoid using drillthrough on the All node, because it may take a very long time to return results.
|Microsoft Cluster Viewer||Cluster Diagram||Click a cluster node.|
|Microsoft Cluster Viewer||Cluster Profiles||Click anywhere in cluster column.|
|Microsoft Association Viewer||Rules tab||Click a row that contains a set of rules.|
|Microsoft Association Viewer||Itemsets tab||Click a row that contains an itemset.|
|Microsoft Sequence Clustering Viewer||Rules tab||Click a row that contains a set of rules.|
|Microsoft Sequence Clustering Viewer||Itemsets tab||Click a row that contains an itemset.|
In SQL Server Data Tools (SSDT), open the mining structure that contains the mining model you want.
In Data Mining Designer, click the Mining Model Viewer tab.
Select the model from the Mining Model drop-down list.
Select a viewer from the Viewer drop-down list, and right-click the specific node.
Select Drill Through, and then select either Models Columns Only, or Model and Structure Columns to open the Drill Through window.
To copy the data to the Clipboard, right-click any row in the table, and select Copy All.