Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Query the Parameters Used to Create a Mining Model


The composition of a mining model is affected not only by the training cases, but by the parameters that were set when the model was created. Therefore, you might find it useful to retrieve the parameter settings of an existing model to better understand the behavior of the model. Retrieving parameters is also useful when documenting a particular version of that model.

To find the parameters that were used when the model was created, you create a query against one of the mining model schema rowsets. In SQL Server 2016 Analysis Services (SSAS), these schema rowsets are exposed as a set of system views that you can query easily by using Transact-SQL syntax. This procedure describes how to create a query that returns the parameters that were used to create the specified mining model.

To open a Query window for a schema rowset query

  1. In SQL Server Management Studio, open the instance of Analysis Services that contains the model you want to query.

  2. Right-click the instance name, select New Query, and then select DMX.


    You can also create a query against a data mining model by using the MDX template.

  3. If the instance contains multiple databases, select the database that contains the model you want to query from the Available Databases list in the toolbar.

To return model parameters for an existing mining model

  1. In the DMX query pane, type or paste the following text:

  2. In Object Explorer, select the mining model you want, and then drag it into the DMX Query pane, between the single quotation marks.

  3. Press F5, or click Execute.

The following code returns a list of the parameters that were used to create the mining model that you build in the Basic Data Mining Tutorial. These parameters include the explicit values for any defaults used by the mining services available from providers on the server.

WHERE MODEL_NAME = 'TM Clustering'

The code example returns the following parameters for the clustering model:

eExample Results:



Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft