Data Sources: 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 Smart View 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.
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.
Related topics: