1. Administering and Working with Enterprise Profitability and Cost Management
  2. Building and Calculating Models
  3. Calculating Models
  4. Using the Calculation Control Page
  5. Clearing a Point of View

Clearing a Point of View

Clearing a point of view allows you to remove data without removing the point of view. You can clear some or all of the data and start over with new or different rules.

To clear a point of view:

  1. On the Calculation Control page, select the point of view you want to clear.

  2. Click Clear icon, or select Actions, and then Clear.

  3. In the Clear Point of View dialog box, select a cube, and then select an option that relates to the level 0 members in the PCM_Balance and PCM_Rule regions.

    Table 11-1 Data that is Cleared for the Selected Point of View

    Clear POV Option PCM_Balance Region Cleared PCM_Rule Region Cleared What this Means

    Input Data

    PCM_Balance.Input

    Level 0 descendants of PCM_Rule

    For all members in all business dimensions, clears the Input member in the PCM_Balance dimension, intersecting with all of the level 0 descendants in the PCM_Rule dimension.

    Adjustment Values

    PCM_Balance.AdjustmentIn

    PCM_Balance.AdjustmentOut

    Level 0 descendants of PCM_Rule

    For all members in all business dimensions, clears the Adjustment In and Adjustment Out members in the PCM_Balance dimension, intersecting with all of the level 0 descendants in the PCM_Rule dimension.

    Allocated Values

    PCM_Balance.AllocationIn

    PCM_Balance.AllocationOut

    PCM_Balance.AllocationOffsetAmount

    Level 0 descendants of PCM_Rule

    For all members in all business dimensions, clears the Allocation In, Allocation Out, and Allocation Offset Amount members in the PCM_Balance dimension, intersecting with all of the level 0 descendants in the PCM_Rule dimension.

  4. Click OK.

  5. Optional: Go to the Jobs console and verify that the data was successfully cleared from the point of view.

    The Clear Point of View job is displayed in the Jobs console with a "Completed" or "Completed with Errors" status. You can select the job to see details about the job and troubleshoot any errors that may have occurred. See Viewing Point of View Jobs.

Note:

You can also use the "Clear Data by Point of View" REST API or the "clearDataByPointOfView" EPM Automate command to clear data. See Clear Data by Point of View in REST API for Oracle Enterprise Performance Management Cloud and clearDataByPointOfView in Working with EPM Automate for Oracle Enterprise Performance Management Cloud.