SubClassType (clsMiningModel)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The SubClassType property of an object of ClassType clsMiningModel returns an enumeration constant identifying the specific subclass type.
Access
Read-only
Remarks
Objects of ClassType clsMiningModel can have a SubClassType property value of sbclsRegular, sbclsOlap, or sbclsRelational. A mining model has a SubClassType value of sbclsRelational if it is defined on one or more relational tables. If the mining model is defined on a cube residing in the same clsDatabase object, the SubClassType value is sbclsOlap. The sbclsRelational constant is equivalent to the sbclsRegular value and is provided for convenience and readability in source code.
Example
The following example prints the types of each data mining model in the FoodMart 2000 database:
' Assume the existance of a server object, s, that has been connected to a server.
Dim db as DSO.DB ' declare an interface for the database.
Dim dmm as DSO.MiningModel
Dim sDmmType as String ' Description of each enumeration value.
set db = s.MDStores("FoodMart")
For each dmm in db.MiningModels
Select Case dmm.subclasstype
Case sbclsOlap
sDmmType = "sbclsOlap"
Case sbclsRelational
sDmmType = "sbclsRelational"
Case else
sDmmType = "Unknown subclass type!"
End Select
debug.print dmm.name & " is type " & sDmmType
Next