Zooming Operations in Cells that Contain Formulas

Data Sources: Essbase

If member cells are associated with formulas, you can propagate these formulas to the members 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, and then select Member Options in the left panel.

  2. Under Comments and Formulas, ensure that Preserve Formulas and Comments on Ad hoc operations (except pivot) is selected.

  3. Select Formula/Format Fill.

  4. Click OK.

Related topics: