Deleting Shared Descendants Using a Utility

Use the DeleteSharedDescendant utility to delete shared dimension members that are descendants of a given member. You can delete shared Entity, Account, and user-defined dimension members. All shared descendant members are deleted, not just immediate children of the specified member.

Administrators run this utility using a command line interface. If the application server or Oracle RMI service is running when the utility is launched, you may see java.rmi or "Port already in use" errors. They do not affect the functionality of the utility.

To use the DeleteSharedDescendants utility:

  1. Launch the DeleteSharedDescendants.cmd file from the planning1 directory on the server where Oracle Hyperion Planning is installed, using this syntax:

    DeleteSharedDescendants [-f:passwordFile] servername username application member

    For the full path to the planning1 directory, see About EPM Oracle Instance.

    Table 12-15 DeleteSharedDescendants Utility Parameters

    Variable Description

    [-f:passwordFile]

    Optional: If an encrypted password file is set up, use as the first parameter in the command line to read the password from the full file path and name specified in passwordFile. See Suppressing Password Prompts in Planning Utilities.

    servername

    The server name on which the Planning application resides.

    username

    The name of the Planning administrator

    application

    The name of the Planning application containing the shared dimension members to delete.

    member

    The member whose shared descendants to delete. If a member name contains a space, surround it by quotation marks (for example, "Member One"). If the shared member itself is specified in the command line, the message "No shared descendants of member_namewere found" is displayed.

    For example:

    DeleteSharedDescendants localhost admin BUDGET account200

  2. If prompted, enter your password.
  3. To see the results of running the utility, check the log files that are generated in the EPM_ORACLE_INSTANCE/diagnostics/logs/planning directory:

    • DeleteSharedDescendants.log: contains status messages.

    • DeleteSharedDescendantsExceptions.log: contains error messages.

If you run this utility while the Manage Database task is open, no error message is displayed, but the member is not deleted. The LOG and CMD files in the EPM_ORACLE_INSTANCE/diagnostics/logs/planning directory show that one shared member was found, but 0 shared members were deleted.