Guidelines for Working with Native Excel Formatting and Oracle Hyperion Planning Forms

Data source types: Oracle Hyperion Planning

• When designing a grid, care should be taken to avoid conflicts between custom Excel formatting and Oracle Smart View for Office cell styles.

• For some ad hoc analysis operations, not all Excel formatting may be preserved. You may need to reapply formatting after performing certain operations.

• When a saved ad hoc grid is opened, Smart View tries to preserve the formatting that was saved to Oracle Hyperion Planning. For further ad hoc operations, existing formatting options apply; for example, Use Excel formatting or cell styles.

• To preserve custom Excel formatting on ad hoc operations, select the Use Excel Formatting and the Move formatting on operations options on the Formatting page of the Options dialog box.

• Formatting can affect performance, especially during ad hoc operations when the Move formatting on operations option is enabled.

• Saving formatting is not recommended on large forms (for example, forms of 20,000 or more cells).

• There are differences between grids rendered in Smart View and those rendered in the browser in Oracle Hyperion Planning. When a saved grid is rendered in Oracle Hyperion Planning, some formatting may not appear exactly as it does in Smart View. Oracle Hyperion Planning will attempt to approximate the Smart View formatting.

• The Oracle Hyperion Planning administrator may have defined certain formatting on a form. Oracle Hyperion Planning end users can overwrite this formatting and save it on the form. It can then be merged with the administrator's formatting based on the option selected for this form in Oracle Hyperion Planning by the administrator. Refer to the Oracle Hyperion Planning documentation for more information.

• Save formatting functionality is not supported on composite forms.

• Ad hoc analysis started from a saved Oracle Hyperion Planning grid will inherit the formatting options saved as part of the grid.

  To use Smart View Cell Styles or the Use Excel Formatting option for an ad hoc grid generated from a saved grid, complete the following steps:

  1. Open the saved Oracle Hyperion Planning grid as a form.

  2. In the Planning ribbon, Formatting group, select Apply, and then None.

  3. Click Save to save the form back to Oracle Hyperion Planning.

  4. Now use the saved form to perform ad hoc analysis.

• Excel formatting and custom styles are intended for use with static grids. Changes to the grid from the following operations can result in invalid formatting:

  • POV

  • Suppression options

  • Merged cells

  • Enabling or clearing the Repeat Member Labels options

  • Adding members to the form definition

Supported Native Excel Formatting summarizes the native Excel formatting supported by forms in Smart View, and whether the formatting is supported when the form is viewed in the Oracle Hyperion Planning web application.