Zooming Operations in Cells that Contain Formulas

Data Sources: 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:

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

Note:

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.
Click OK.