FormatString (Measure Interface)
From Analysis Services Programming
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
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 = "#,###.##"