Analysis Services Programming

FormatString (Measure Interface)

The FormatString property of the Measure interface contains the format used to display the measure values. Any format string valid for use with Microsoft® Visual Basic® is acceptable.

Applies To

clsAggregationMeasure

clsCubeMeasure

clsPartitionMeasure

Data Type

String

Access

Access depends on the value of the ClassType property of the object.

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

* Read-only for virtual cube measures.

Example

Use the following code to set the format string for the measure object [Sales_Facts].[Price]:

'Assume an object (dsoCubeMea) of ClassType clsCubeMeasure exists
dsoCubeMea.FormatString = "#,###.##"

See Also

Measure Interface