Analysis Services Programming
Description (clsColumn)
The Description property of an object of ClassType clsColumn sets or returns the description of the column. This property is reserved for future reference in Decision Support Objects (DSO) and is not available to client applications.
Data Type
String
Access
Read/write
Examples
A. Setting the Description Property
Use the following code to set the Description property for a clsColumn object:
' Assume an object (dsoColumn) of ClassType clsColumn exists
dsoColumn.Description = "Number Sold"
B. Adding a Column to a Mining Model and Setting the Column Description Property
The following example creates a new column in the mining model and sets a number of properties, including the Description property:
'------------------------------------------------------------------------
' Add a new column to the mining model called Gender and relate this
' column to the Gender member property of the Name level of the
' Customers dimension. Declare that the data in this column is
' statistically discrete.
' Assume the existence of a DSO Level object, dsoLv.
'------------------------------------------------------------------------
'Add another column to the model.
Set dsoColumn = dsoDmm.Columns.AddNew("Gender")
'Identify the member property of the Customers dimension
'that this column is based on.
'Set the column's description for browsers of the schema.
Set dsoColumn.Description = "Based on the Gender member property " & _
"of the Name level of the Customers dimension."
Set dsoColumn.SourceOlapObject = dsoLvl.MemberProperties("Gender")
'Identify its type.
dsoColumn.DataType = adWChar
'Make this column related to the Customer Id column.
dsoColumn.RelatedColumn = "Customer Id"
'Identify this column as containing discrete data.
dsoColumn.ContentType = "DISCRETE"