SourceColumn

The SourceColumn property of the Measure interface contains a reference to the column in the fact table that contains the measure.

Applies To
clsAggregationMeasure clsPartitionMeasure
clsCubeMeasure  


Note For a virtual cube (a cube object with a SubClassType of sbclsVirtual) the SourceColumn property is used to reference a measure within an existing cube rather than a column in a source fact table. For more information, see clsCube.


Data Type

String

Access

The access type depends on the measure object’s class.

Class Access
clsCubeMeasure R/W
clsPartitionMeasure R/W
clsAggregationMeasure R

Remarks

The SourceColumn property works in conjunction with the SourceColumnType property.

Example

Use the following code to set a measure object SourceColumn to “Sales_Facts”.”Price”:

'Assume an object (dsoCubeMea) of ClassType clsCubeMeasure exists

dsoCubeMea.SourceColumn = """Sales_Facts"".""Price"""

See Also
About Decision Support Objects Using Decision Support Objects
Properties Cross-Reference  

(c) 1988-1998 Microsoft Corporation. All Rights Reserved.