Deleting a Formula Component (Essbase Aggregate Storage Application Users and Oracle General Ledger Users Only)

You can delete a formula component only if it is not being used in any business rules. To see if any business rules are using the formula component, you can show the formula component's usages. See Showing a Formula Component's Usages (Essbase Aggregate Storage Application Users and Oracle General Ledger Users Only).

If the formula component is being used by a business rule, and you no longer need to use the formula component in that rule, remove it from the rule, then delete the formula component. If the formula component is being used in a business rule, and you no longer need the business rule, you can delete the business rule.

If no business rules use the formula component, you can delete the component.

  To delete a formula component:

  1. In the System View, expand the Essbase application type, the Essbase aggregate storage application, the database, and Formulas.

  2. Right-click the formula you want to delete, and select Show Usages to make sure no business rules are using the formula component. See Showing a Formula Component's Usages (Essbase Aggregate Storage Application Users and Oracle General Ledger Users Only).

  3. Remove the formula component from any business rules that are using it. See Removing a Component from a Flow Chart (Financial Management, Planning, and Essbase Block Storage Application Users Only).

  4. In the System View, right-click the formula you want to delete, and select Delete.

  5. Confirm deletion of the formula.