MINING_SERVICE_PARAMETERS

Analysis Services Programming

Analysis Services Programming

MINING_SERVICE_PARAMETERS

This schema rowset provides a list of parameters that can be supplied when you are generating a mining model using the CREATE MINING MODEL statement. The client application will often restrict by SERVICE_NAME to obtain the parameters that are supported by the provider and are applicable to the type of mining model being generated.

Column name Type indicator Description
SERVICE_NAME DBTYPE_WSTR The name of the algorithm.
PARAMETER_NAME DBTYPE_WSTR The name of the parameter.
PARAMETER_TYPE DBTYPE_WSTR The OLE DB data type of the parameter.
IS_REQUIRED DBTYPE_BOOL TRUE if the parameter is required.
PARAMETER_FLAGS DBTYPE_UI4 A bitmap that describes parameter characteristics. The following bit value constants are defined in Msmd.h for this bitmap:
  • DM_PARAMETER_TRAINING (0x0000001)
    For training

  • DM_PARAMETER_PREDICTION (0x00000002)
    For prediction
DESCRIPTION DBTYPE_WSTR Text that describes the purpose and format of the parameter.

Default Sort Order

SERVICE_NAME
PARAMETER_NAME

Restriction Columns

SERVICE_NAME
PARAMETER_NAME