Creating Formatting Definitions

  To create formatting definitions:

1. Right-click a column or row dimension header.

2. Select Formatting.

   The Formatting dialog box is displayed.

3. Optional. To display the Dimensions panel, click Advanced.

4. To select a dimension, click its check box.

   If you select one dimension from the Dimensions panel, the corresponding dimension members are displayed in the Combinations panel.

   If you select multiple dimensions from the Dimensions panel, the Combinations panel displays dimension member aggregations.

5. To specify dimension members, click the check boxes in the Combinations panel.

6. To specify a formatting definition, perform an action:

   • To specify header cell font properties for the dimension member selection, click the Header Font tab.

   • To specify data cell font properties for the dimension member selection, click the Data Font tab.

   • To specify leading and trailing text and numeric formatting, click the Data Format tab. See Formatting Data.

     Note:

     The Data Font and Data Format tabs provide conditional formatting where you can refine formatting definitions. Select Conditional Formatting, then select an operand and specify a value.

7. Click OK to accept the formatting definition properties for the dimension member selection.

   The formatting definition is listed in Analysis Tools Manager for future reference, and the definition is applied to the document.