Member Formula

Data source types: Oracle Hyperion Planning

If you are unfamiliar with Planning, see the Oracle Hyperion Planning User's Guide, available in the Oracle Help Center. To open this library, from the Smart View ribbon, select the arrow next to Help, and then Documentation.

Note:

In the Planning web interface, the Member Formulas property must be enabled in the form before you can view formulas in Oracle Smart View for Office. Users with the proper permissions should open the form in Planning, go to the Layout tab, then Dimension Properties, and then select Member Formulas.

You can view the underlying formula in cells that contain a formula. Such cells can be indicated on the grid by a cell style specified in the Options window. To view a member formula:

  1. Select the member whose formula you want to view.
  2. From the Planning or Planning Ad Hoc ribbon, select More, and then Member Formula.

    Details of the formula are displayed.