Using Smart View Formatting

Data source types: Oracle Essbase, Oracle Analytics Cloud - Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Tax Reporting Cloud

Oracle Smart View for Office formatting consists of formatting selections made in the Cell Styles and Formatting tabs of the Options dialog box.

To set Smart View formatting options:

  1. From the Smart View ribbon, click Options.

  2. From Options, to set cell styles, select Cell Styles in the left pane.

    Cell styles indicate certain types of member and data cells.

    See Cell Styles for more information

  3. To set other Smart View formatting options, select Formatting from the left pane (Use Excel Formatting on this page is not a Smart View formatting option).

    See Smart View Options for descriptions of options.

  4. Click OK.

To apply Smart View formatting selections to data cells created by zooming:

  1. From the grid, select a formatted data cell.

  2. From the Essbase or Planning Ad Hoc ribbon, select Preserve Format.