Zooming Operations in Cells that Contain Formulas

Applies to: Oracle 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 Smart View ribbon, click Options to launch the Options panel.
2. In the Options panel, select the Members tab.
3. Under Comments and Formulas, ensure that Preserve Formulas and Comments in Ad Hoc is selected.
4. 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 may take a long time to complete.
   • Though the Formula Fill option appears in Members tab, it applies to formulas in both member and data cells.
5. Open an ad hoc grid and select a member or data cell with formula.
6. From the Essbase ribbon, click the down arrow next to Zoom In, and then select the level you want to zoom in.
   The formula is propagated to the cells retrieved as a result of zooming in.