1. Working with Oracle Smart View for Office
  2. Free-Form Mode
  3. Formulas in Free-Form Grids

Formulas in Free-Form Grids

Data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud

You can enter Excel formulas in cells that can contain comments.

Note:

Excel formulas are not saved to the provider server in the free-form worksheet. For example, if you use the Save Ad Hoc Grid command with a Oracle Hyperion Planning free-form or ad hoc grid, the formulas are not saved. However, you can retain formulas in a worksheet by performing a Save in Excel and saving the workbook.

Figure 22-12 shows a grid from an Essbase data source with Excel formulas in cells C8 and F8.

Figure 22-12 Formulas in Essbase Free-Form Grid in Excel


Shows a valid grid as described in the previous paragraph.

Figure 22-13 shows a grid from a Planning data source with Excel formulas in cells B8 and C7.

Figure 22-13 Formulas in Planning Free-Form Grid in Excel


Shows a valid grid as described in the previous paragraph.

For information about unexpected behavior that may occur, see Actions That May Cause Unexpected Behavior.