Review Member Formulas

Review member formulas to optimize calculations and logic and to remove unnecessary formulas. You can review member formulas using Oracle Smart View for Office.

Use the Edit Member Properties screen to review, edit, and remove formulas from a dimension. You can remove formulas only from custom dimensions. Seeded formulas on default (out-of-the-box) dimensions, for example, YTD, cannot be removed.

To edit or remove formulas from custom dimensions:

  1. Sign in to Tax Reporting as a Service Administrator.
  2. On the Home page, click Application and then Overview.
  3. Click Dimensions to open the Simplified Dimension Editor.
  4. Click the name of the dimension that you want to work with.
  5. Click Zoom in All Levels Zoom in All Levels.
  6. In the Consol Formula column, locate the formula that you want to edit or remove.
    Edit Consol Formula screen
    To declutter the screen, you may remove columns from the current view by right-clicking in the column header and deselecting some columns.
  7. Edit or delete the formula, as needed, and then click Save to preserve your changes.
  8. Click Save and then Cancel in Edit Member Properties.