Modeling Flags (DMX)

You can use modeling flags in Microsoft SQL Server 2005 Analysis Services (SSAS) to provide additional information to a data mining algorithm about the data that is defined in a case table. The algorithm can use this information to build a more accurate data mining model. You can define modeling flags on both mining structure columns and mining model columns.

Analysis Services supports the following modeling flags:

NOT NULL

The values for the attribute column should never contain a null value. An error will result if Analysis Services encounters a null value for this attribute column during the model training process. This flag is defined on a mining structure column.

REGRESSOR

Indicates that the algorithm can use the specified column in the regression formula of regression algorithms. This flag is supported by the Microsoft Linear Regression and Microsoft Decision Trees algorithms, and is defined on a mining model column.

MODEL_EXISTENCE_ONLY

The values for the attribute column are less important than the presence of the attribute. This flag is defined on a mining model column.

Third-party algorithms may support additional modeling flags. To determine which modeling flags an algorithm supports, use the SUPPORTED_MODELING_FLAGS schema rowset. For more information about the modeling flags that Analysis Services supports on a mining structure column, see Modeling Flags (Data Mining). For more information about the modeling flags that Analysis Services supports on a mining model column, see Mining Model Columns.

Community Additions

ADD
Show: