Formats for Data Values

You can specify how values should be formatted for certain types of attributes in a cube. Value formatting controls how the values appear to users in their BI tools. Setting the format preference in the AtScale cube ensures that all BI users see the data values in the same way.

• Number Format Strings You can specify how number values are formatted for any measure or numeric-type dimension (INT, INTEGER, LONG, FLOAT, DOUBLE, or DECIMAL data types).
• Boolean Format Strings You can specify how values are formatted for attributes of BOOLEAN data types.
• Date and Time Format Strings You can specify how values are formatted for attributes of DATETIME or DATE data types.