The Formatting dialog box indicates the members to which these formats are applied:
Restore default formatting preferences.
Control | Description |
|---|---|
Selections | Lists dimensions and members in the query. The dimensions that appear are based on the context of where the Formatting dialog box was invoked. For example, if Formatting is invoked from the rows, all row dimension and members are displayed. If Formatting is invoked from a cell, all dimensions and members in the query are listed. |
Advanced | Shows the Dimension panel that enables you to select or deselect dimensions and apply formatting to specific dimension combinations. This mainly applies when there are two or more dimensions in the columns or rows. |
Dynamic References | Provides selection of row or column references instead of selecting members from a report. Formatting is applied regardless of the member selection. |
Apply to entire grid | Applies formatting defined to the entire spreadsheet query. When selected, the Selections section is grayed and a Formatting “All Members” item is added to the Analysis Tools Manager. |
Header Font tab | Allows formatting of member labels fonts in the row and column headers. |
Data Font tab | Allows formatting of data cells fonts. Conditional font or number formatting can be applied to specific data values that meet the defined criteria. |
Data Format tab | Provides formatting to specific data values such as currency/prefix/suffix, as well as other numeric formatting. Conditional font or number formatting can be applied to specific data values that meet the defined criteria. |
Conditional Formatting | Enables conditional formatting of dimension member selections based on the criteria defined in the operand drop-down list and value text box. |
Conditional Formatting — Operand drop-down list | Specifies the conditional formatting operand: >, >=, =, <=, <, or <>. |
Conditional Formatting — Value Text box | Specifies the conditional formatting value. |
Restore Defaults | Restores the settings specified by the Default Formatting preferences. |
The behavior for the members that are selected prior to opening the Formatting dialog:
When you right-click a column or row header and select Formatting, the context is completed automatically for the row or column member selections. This context can be edited and different member selections can be made.
When you right-click a cell and select Cell Formatting, the context is completed for the cell intersection of members. This context cannot be edited.
When you right-click a column or row header and select Analysis Tools, then Format, the Formatting dialog is opened without completed context.
If the number of members in a dimension on a report exceeds 25, the dimension parent node is collapsed. You can click the node to expand it.
If there is more than one dimension in the rows or columns, you can select from one dimension only or multiple dimensions.
Instead of selecting members from a report, you can use Dynamic References to select a row or column reference. Formatting is applied regardless of the member selection. Also:
If a member is drilled on, its formatting will “carry with it”.
If a swap or pivot is performed, the formatting will “carry” where possible.