Clearing Data

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

Note:

Select only unlocked cells when you clear data. Otherwise, the data clear fails.

Web Procedure

  To clear data:

  1. Open the application from which to clear data.

  2. Select Browser View.

  3. In the view pane, expand Tasks and select Data Tasks.

  4. Select Database Management and select Clear Data.

  5. From the Point of View bar, select a scenario and year, and select the period, entity, and account dimension members to clear.

  6. From Value Dimension, select an option:

    • Entity Currency to clear the data in the Entity Currency member of the Value dimension

    • Rates and Systems to clear data from system accounts

  7. Optional: To store the clear information in a log file, select Enable Detailed Logging.

  8. Click Clear Data.