Display Formats
You can select the format in which measure values are displayed to end users by using the Display Format property of the measure. This property is accessed in the properties pane of Cube Editor.
Although the properties pane provides a dropdown list for the Display Format property, you can specify many additional formats that are not in the list. You can specify named or user-defined formats that are valid in Microsoft® Visual Basic®. The following table contains some examples. They assume the regional setting in Control Panel on the client computer is English (United States).
| Source data type | Named/user-defined format | Display Format value | Example output |
|---|---|---|---|
| Numeric | Named | General Number | 123456789 |
| 0 | |||
| Fixed | 123456789.00 | ||
| 0.00 | |||
| User-defined | $#,#.00 | $123,456,789.00 | |
| $.00 | |||
| #,#0.0000 | 123,456,789.0000 | ||
| 0.0000 | |||
| Date/time | Named | Medium Date | 31-Dec-99 |
| Long Date | Friday, December 31, 1999 | ||
| User-defined | mm/dd/yyyy | 12/31/1999 | |
| mmm-dd-yyyy | Dec-31-1999 | ||
| Boolean | Named | Yes/No | Yes |
| True/False | True |
For more information about valid named and user-defined formats, search on "format expression" in the Visual Basic section in the MSDN® Library at the Microsoft Web site.
Note In client applications, some display formats do not translate appropriately for all locales. If you are supporting multiple locales or a locale different than that of the Analysis server, you should test the display formats in client applications on computers set to those locales.