Properties, Measure Interface

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 Measure interface supports the following properties.

Property	Description
AggregateFunction	Sets or returns a value that corresponds to the type of aggregate function used for a measure
ClassType	Returns an enumeration constant that identifies the specific object type
Description	Sets or returns the measure description
FormatString	Sets or returns the format used to display the measure values
IsValid	Indicates whether the measure object is valid
IsVisible	Indicates whether the measure is visible to client applications
Name	Sets or returns the measure name
OrdinalPosition	Returns the ordinal position of the measure in the parent object's Measures collection
Parent	Returns a reference to the parent MDStore object
SourceColumn	Sets or returns the name of the column that is precalculated
SourceColumnType	Sets or returns the data type of the measure source column
SubClassType	Returns an enumeration constant that identifies the subclass type of the object

Access Cross-Reference

The following table shows whether the property is read/write (R/W) or read-only (R) for different objects.

Property	clsCube Measure	clsPartition Measure	clsAggregation Measure
AggregateFunction	R/W*	R	R
ClassType	R	R	R
Description	R/W	R	R
FormatString	R/W*	R	R
IsValid	R	R	R
IsVisible	R/W	R	R
Name	R/W (R after the object has been named)	R/W (R after the object has been named)	R/W (R after the object has been named)
OrdinalPosition	R	R	R
Parent	R	R	R
SourceColumn	R/W	R/W	R
SourceColumnType	R/W*	R	R
SubClassType	R	R	R

* This property is read-only (R) for virtual cubes (that is, those of SubClassType sbclsVirtual).

See Also

Reference

Measure Interface

Help and Information

Getting SQL Server 2005 Assistance