Formatting Query Results in Smart View

Profitability and Cost Management displays results data within Smart View from the Rule Balancing screen, the Trace screen, and when running a query.

By default, results display with special formatting that makes it easier to interpret and present data. For example, cell colors make it easier to tell editable cells from read-only cells.

Cell style options are global options, which apply to the entire current workbook, including any new worksheets added to the current workbook, and to any workbooks and worksheets that are created after global options are set. You can use the Oracle Smart View for Office Options settings to change these defaults. Because cells may belong to more than one type—a member cell can be both parent and child, for example—you can also set the order of precedence for how cell styles are applied.

To specify a style:

1. In Smart View, select Options.

2. On the Cell Styles page, select PCM.

3. Expand the list of available cell types.

   This enables you to view current cell type formatting.

4. Select a cell type.

5. Select Properties and specify a font, background color, or border.

   You can set only one style per cell type. For example, you may set a background style or a font style for Parent members, but you cannot set both a background and font style for Parent members.

6. To reorder precedence of cell styles, use the Move Up and Move Down buttons or drag and drop the cell styles.

7. Click OK. The setting takes effect after you refresh or perform a drill operation.

8. Optional: To revert cell styles or precedence to the default styles of Profitability and Cost Management, click Reset.

9. Optional: To set your selections on this page as default settings, click the arrow in the OK button, and then select Default Styles.

For more information, see "Cell Styles" in Oracle Smart View for Office User's Guide.