Logical Data Warehouse Design - Data Warehouse Systems: Design and Implementation - page 158

Fig. 5.29 Definition of the Northwind cube in Analysis Services. ( a ) Measure groups.
( b ) Dimensions. ( c ) Schema of the cube
The FormatString property is used to state the format in which the
measures will be displayed. For example, measures Unit Price , Sales Amount ,
and Freight are of type money, and thus, their format will be $###,###.00 ,
where a ' # ' displays a digit or nothing, a ' 0 ' displays a digit or a zero, and
',' and '.' are, respectively, thousand and decimal separators. The format
string for measures Quantity and Sales Count will be ###,##0 . Finally, the
format string for measure Discount will be 0.00% , where the percent symbol
' % ' specifies that the measure is a percentage and includes a multiplication
by a factor of 100.
Further, we can define the default measure of the cube, in our case Sales
Amount .AswewillseeinChap. 6 , if an MDX query does not specify the
measure to be displayed, then the default measure will be used.