Display Format Attributes

The Cube Viewer window displays numeric data in the formats shown in the following table.

Format Name	Description	Example
Currency	Numbers appear with a currency symbol and the specified number of decimal places (Precision). TM1® uses the currency symbol defined in the Microsoft Windows Regional Settings dialog box.	$90.00
General	Numbers appear with a specified number of decimal places (Precision).	-90
Percentage	Numbers appear as percentages, with a specified number of decimal places (Precision).	90.00%
Scientific	Numbers appear in exponential form, with a specified number of decimal places (Precision).	9.0e+001
Date	Numbers appear as a date string. 1=January 1, 1900. There are a number of date formats available.	March 31, 2002
Time	Numbers appear as a time string. There are a number of time formats available.	19:53:30 A
Comma	Places commas in the appropriate places in large numbers.	1,000,000
Custom	A user-defined format.	Custom

Using the Attributes Editor window, you can select a display format for every element in each dimension in a cube. However, it is recommended that you select display formats only for one dimension, the measures you track in a cube. You can also select a format in the Cube Viewer window that applies to cells whose elements do not have a display format defined.

TM1 determines which display format to use in the Cube Viewer window, as follows:

Procedure

TM1 first checks the elements in the column dimension for display formats. If dimensions are stacked, TM1 checks from the bottom upward.
If no format is found, TM1 checks the elements in the row dimension for display formats. If dimensions are stacked, TM1 checks from right to left.
If no format is found, TM1 checks the title elements for display formats. The elements are inspected from right to left.
If no format is found, TM1 applies the format for the current view.
To ensure that TM1 applies the format for the cube measures, position the dimension containing the measures as the bottommost column dimension.