Browse a Model Using the Microsoft Generic Content Tree Viewer
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
The Microsoft Generic Mining Model Content Viewer provides detailed information about the patterns found by the mining algorithm, and also provides access to various statistics generated during the analysis process. The amount and type of information depends on the algorithm that was used, but can include the following categories:
Segments of data, and their characteristics.
Descriptive statistics about each group or about the whole set of data.
The number of branches or child nodes in a tree.
Calculations, such as variance and mean, for a cluster or a whole set of data.
Viewing this information can help you better understand the results of your analysis. You can also identify ways to fine-tune, and then retrain, your model. Or, you might decide to retrain by using a different algorithm.
The Microsoft Generic Content Viewer displays the columns, rules, properties, attributes, nodes, and other content from the content schema rowset of the mining model. The content schema rowset is a generic framework for presenting detailed information about the content of a data mining model.
This detailed information is contained in an HTML table that represents the patterns, clusters, or trees in the model as nodes. You can click on each node and expand it to see more detail, such as the formulas or the count of distinct values for a numeric attribute. You can also explore the child-parent relationships among the nodes.
For more information about the general meaning of the terms used in the mining model content, see Mining Model Content (Analysis Services - Data Mining). The topic also contains links to information about mining model content for specific types of models. Each type of mining model contains information that is highly specific to the algorithm and the patterns found in the data, so we recommend that you consult the technical reference topic for each model type in order to fully understand each model type.
The same information that is provided by the Microsoft Generic Content Tree Viewer is also available by querying the mining model. You can create queries against mining model content by using Data Mining Extensions (DMX) statements. For example, in SQL Server Management Studio, you can run a content query by executing the following DMX statement:
SELECT * FROM [<mining model name>].CONTENT
For more information, see Data Mining Queries.