Zooming Operations in Cells that Contain Formulas

Data Sources: Oracle Essbase, Oracle Analytics Cloud - Essbase

If member or data cells are associated with formulas, you can propagate these formulas to the cells retrieved as a result of zooming in. For example, if member Qtr1 is associated with a formula, then the formula can be propagated to Jan, Feb, and Mar when you zoom in on Qtr1.

To propagate formulas:

  1. From the Oracle Smart View for Office ribbon, click Options, and then select Member Options in the left panel.
  2. Under Comments and Formulas, ensure that Preserve Formulas and Comments in ad hoc operations (except pivot) is selected.
  3. Select Formula Fill.

    Note:

    • With the Formula Fill option enabled, some zoom operations may be time consuming. For example, a zoom in to the bottom level of a large hierarchy (described in Zooming in to a Selected Level) may take a long time to complete.

    • Although these options—Preserve Formulas and Comments in ad hoc operations (except pivot) and Formula Fill—appear in Member Options, they apply to formulas in both member and data cells.

  4. Click OK.

Related Topics: