Member Formula

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 Oracle Smart View for Office Options dialog box, Cell Styles tab.

Data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting

Note:

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

To view a member formula:

1. Open a form or ad hoc grid.
2. Select the member whose formula you want to view.
3. From the provider ribbon, select More, and then Member Formula.

   Details of the formula are displayed.

   Note:

   When a formula is used to reference a member on another sheet, no data is returned. For example, if the period is in the column on another sheet, and all other sheets reference that cell, no data is refreshed on the other sheets. In order to display the data that references a member on another sheet, the Excel cell format for the member formula cell should be set to "General."