The formatting order of precedence can be changed for Database Connection Measures formatting, User Preferences, and Analysis Tools formatting. For example, Analysis Tools formatting can be set override all DB Connection and User Preferences formatting for a specific report. Formatting is applied an order of precedence:
Measures formatting — Applied globally to dimensions on database connections. Settings are saved with the database connection. See Creating OLAP and Oracle | Hyperion Database Connections.
Default formatting preferences — Applied globally to column and row headers, and data values. Settings are saved in preference files. See Default Formatting Preferences.
Formatting — Applied ad hoc from the data object shortcut menu on dimension members. It is stored with the document definition and applied as a preliminary Analysis Tool definition. See Formatting Dialog Box.
Data formatting analysis tool — Applied after Data Formatting Analysis Tool definitions are created and applied. It is stored with the document and applied from the Analysis Tools Manager. See Data Formatting.
Cell formatting — Applied ad hoc to cell ranges, and is stored with the document. See Formatting Data.
Preferences and formatting options:
There are some identical formatting options and preferences. Preferences are global settings applied to documents. Preferences, however, can be overridden by database connection formatting and document-based formatting.
The formatting order of precedence can be changed for Database Connection Measures formatting, User Preferences, and Analysis Tools formatting. For example, Analysis Tools formatting can be set to override all Database Connection and User Preferences formatting for a specific report.