**THIS TOPIC APPLIES TO:**SQL Server (starting with 2008)Azure SQL DatabaseAzure SQL Data Warehouse Parallel Data Warehouse

You can use modeling flags in Analysis Services 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. You can also query the mining services on the server to determine which modeling flags are supported for a particular algorithm. For example, the following query returns the modeling flags are supported for the Microsoft Linear Regression algorithm on the current server:

```
SELECT SUPPORTED_MODELING_FLAGS
FROM $SYSTEM.DMSCHEMA_MINING_SERVICES
WHERE SERVICE_NAME = 'Microsoft_Linear_Regression'
```

Expected results:

NOT NULL,REGRESSOR

## Specifying Modeling Flags on a Mining Model

For examples of the syntax that Analysis Services supports for specifying a flag on a mining structure column, see CREATE MINING STRUCTURE (DMX).

For an example of the syntax for specifying a modeling flga on a mining model column, see ALTER MINING STRUCTURE (DMX).

For more information about working with mining model columns, see Mining Model Columns.

## See Also

Data Mining Algorithms (Analysis Services - Data Mining)

Data Mining Extensions (DMX) Reference

Data Mining Extensions (DMX) Syntax Elements

Data Mining Extensions (DMX) Function Reference

Data Mining Extensions (DMX) Operator Reference

Data Mining Extensions (DMX) Statement Reference

Data Mining Extensions (DMX) Syntax Conventions

General Prediction Functions (DMX)

Structure and Usage of DMX Prediction Queries

Understanding the DMX Select Statement