CaseLevel (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 CaseLevel property of an object of ClassType clsMiningModel identifies the level of the CaseDimension that contains the cases for the mining model. This property applies only to mining models of SubClassType sbclsOlap.
Data Type
String
Access
Read-only
Remarks
The value of the CaseLevel property represents the name of the lowest enabled and visible level of the dimension specified in the CaseDimension property.
Example
The following example builds an OLAP data mining model and sets its case dimension to Customers. The lowest enabled and visible level in the Customers dimension is Name, so the CaseLevel property is set to the Name level.
dsoDmm.Description = "Analyzes the purchasing behavior of customers"
dsoDmm.MiningAlgorithm = "Microsoft_Decision_Trees"
dsoDmm.SourceCube = "Sales"
dsoDmm.CaseDimension = "Customers"
' Save the changes to the data mining model. This also populates
' the Columns collection and sets the CaseLevel property.
dsoDmm.Update
' The dsoDmm.CaseLevel property should have a value of "Name",
' the lowest enabled level of the Customers dimension.
Debug.Print dsoDmm.CaseLevel