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. Copying a Point of View

Copying a Point of View

You can copy data from one point of view to another. For example, if you wanted to create a "what if" version of the point of view, you could start with data that was already included in an existing point of view, copy it to a new point of view, and then do some additional edits and calculations.

To copy a point of view:

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

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

  3. In the Copy Point of View dialog box, select a Source cube and a Destination cube.

  4. Select the members for the Years, Period, Scenario, and Version dimensions that will be used in the copied point of view.

  5. Under Data, select an option that relates to the level 0 members in the PCM_Balance and PCM_Rule regions.

    Table 11-2 Data that is Copied for the Selected Point of View

    Copy POV Option PCM_Balance Region Copied PCM_Rule Region Copied What this Means

    All Input Data

    Level 0 descendants of PCM_Balance

    PCM_Rule.NoRule

    For all members in all business dimensions, copies all level 0 descendants in the PCM_Balance dimension, intersecting with the NoRule member in the PCM_Rule dimension.

    All Data

    Level 0 descendants of PCM_Balance

    Level 0 descendants of PCM_Rule

    For all members in all business dimensions, copies all level 0 descendants in the PCM_Balance dimension, intersecting with all of the level 0 descendants in the PCM_Rule dimension. This results in all of the data in the POV being copied.

  6. Click OK.

    Note:

    If you select options for Years, Period, Scenario, and Version to define a point of view that doesn't exist in the calculation control list yet, a dialog box is displayed letting you know that the destination point of view doesn't exist. Click OK to confirm that you want to create the destination point of view.

  7. Optional: Go to the Jobs console and verify that the point of view was copied successfully.

    The Copy 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 "Copy Data by Point of View" REST API or the "copyDataByPointOfView" EPM Automate command to copy data. See Copy Data by Point of View in REST API for Oracle Enterprise Performance Management Cloud and copyDataByPointOfView in Working with EPM Automate for Oracle Enterprise Performance Management Cloud.