Clearing Data

You can clear data for selected entities and accounts for a specific scenario, year, period, or list of periods. When you clear data, both base and parent entities are cleared. However, only base-level accounts are cleared. You cannot clear any cells that contain posted intercompany transactions.

Note:

You must select only unlocked cells when you clear data, or the clear process does not complete successfully.

To clear data, you must have the Database Management security role.

To clear invalid records from the database, you must be an administrator. See the Oracle Hyperion Financial Management Administrator's Guide.

To clear data:

  1. Open the application from which to clear data.
  2. Select Consolidation, then Data, and then Manage.
  3. From the Manage Data page, expand Clear Data.
  4. From Source, select a Scenario and Year, and select the Period, Account, and Entity dimension members to clear.
  5. From Options, select one or more options:
    • Entity Currency Data to clear the data in the Entity Currency member of the Value dimension

    • Rates and System Data to clear data from system and exchange rate accounts

  6. Optional: To store the clear information in a log file, select Enable Detailed Logging.
  7. Click Clear.
  8. At the confirmation prompt, click Yes to clear data.