| title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
|---|---|---|---|---|---|---|---|---|
View or Change Modeling Flags (Data Mining) | Microsoft Docs |
Learn how to view and modify the modeling flags associated with a mining structure or mining column in Data Mining Designer in SQL Server Analysis Services. |
10/31/2023 |
analysis-services |
data-mining |
conceptual |
kfollis |
kfollis |
kfollis |
[!INCLUDEappliesto-sql2019-earlier]
[!INCLUDEdm-dep-banner]
Modeling flags are properties that you set on a mining structure column or mining model columns to control how the algorithm processes the data during analysis.
In Data Mining Designer, you can view and modify the modeling flags associated with a mining structure or mining column by viewing the properties of the structure or model. You can also set modeling flags by using DMX, AMO, or XMLA.
This procedure describes how to change the modeling flags in the designer.
-
In SQL Server Design Studio, open Solution Explorer, and then double-click the mining structure.
-
To set the NOT NULL modeling flag, click the Mining Structure tab. To set the REGRESSOR or MODEL_EXISTENCE_ONLY flags, click the Mining Model tab.
-
Right-click the column you want to view or change, and select Properties.
-
To add a new modeling flag, click the text box next to the ModelingFlags property, and select the check box or check boxes for the modeling flags you want to use.
Modeling flags are displayed only if they are appropriate for the column data type.
[!NOTE]
After you change a modeling flag, you must reprocess the model.
-
In [!INCLUDEssManStudioFull], open a DMX Query window, and type a query like the following:
SELECT COLUMN_NAME, CONTENT_TYPE, MODELING_FLAG FROM $system.DMSCHEMA_MINING_COLUMNS WHERE MODEL_NAME = 'Forecasting'