Modeling Flags (DMX)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
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:
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'
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.