Deleting Members

Caution!

Each data value is identified by a set of dimension member values and a plan type. Deleting dimension members or deselecting the plan type results in data loss when refreshing applications. Deleting entity members deletes all planning units (including data) associated with them. Before beginning this procedure, perform a backup. See Backing Up Applications and Application Databases and the Oracle Hyperion Enterprise Performance Management System Backup and Recovery Guide.

Before deleting members, understand where in the application they are used (in which data forms, planning units, exchange rates, and so on) by using Show Usage.

You must delete the entity member throughout Planning before deleting it from Dimensions. For example, if the entity member is used in a data form, you must delete it from the data form before deleting it from Dimensions.

When deleting a large subtree of entities, you can improve performance if you first exclude planning units for the subtree (by excluding the root member) for all scenarios and versions. See Review Process.

To delete members:

Select Administration, then Manage, then Dimensions.
Select the dimension whose member you want to delete.
From the dimension hierarchy, select the entity member to delete.
Click Delete.
Deleting a base member also deletes its shared members.
Click OK.
Update and validate business rules and reports.