Mining Model Properties

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.

Mining models have the following kinds of properties:

  • Properties that are inherited from the mining structure that define the data type and content type of the data used by the model;

  • Properties that are related to the algorithm used to create the mining model, including any customer parameters;

  • Properties that define a filter on the model used to train the model.

The properties of a mining model are initially defined when you create the model; however, you can alter most properties later, including the algorithm parameters, filters, and column usage properties. You change properties by using the Mining Models tab of Data Mining Designer, or by using AMO or XMLA.

Whenever you change any property of a model, you must reprocess the model for the changes to be reflected in the model. Reprocessing is required even if the change only involves metadata, such as adding a column alias or description.

Properties of Models

The following table describes the properties that are specific to mining models. Additionally, there are properties that you can set on individual columns in the mining

Property Description
Algorithm Sets the algorithm type for the mining model.
AlgorithmParameters Sets values for algorithm parameters that are available for each algorithm type.
Filter Sets a filter that is applied to the data that is used for training and testing the mining model. The filter definition is stored with the model and can be used optionally when you create prediction queries, or when you test the accuracy of the model.

The model filter is not optional when training the model.
Name Sets the name of the mining model.
AllowDrillThrough Specifies whether drill through is enabled on the mining model.

Properties of Model Columns

You can set the following data mining-specific properties for each column in a mining model. You can set these properties to a different value for each mining model in a mining structure.

Property Description
Description Describes the purpose of the mining column.
Name Sets the name of the mining model column. You can type a new name, to provide an alias for the mining model column.
ModelingFlags Sets any algorithm-specific flags for the column.
SourceColumnID Indicates the name of the mining structure column on which the model column is based.

This property is read-only.
Usage Sets how the column will be used by the mining model.

See Also

Mining Model Columns
Mining Structures (Analysis Services - Data Mining)
Mining Model Tasks and How-tos
Change the Properties of a Mining Model
Data Mining Tools
Create a Relational Mining Structure
Create an Alias for a Model Column