Copying Data

You can copy plans from one dimensional intersection to another, including relational data and supporting detail. For example, you can copy Budget, FY10, Final to Forecast, FY11, First Draft.

Notes:

  • Selected Copy Data settings are preserved for the current session only.

  • Copied dimension members must be present in the selected plan types.

  • Data must be copied into cells that can accept data. For example, you cannot copy data into read-only or dynamic cells.

  • You can copy account annotations, supporting detail, and cell text. You cannot copy planning unit annotations.

  • You cannot use this feature with attributes, so do not select attributes to be copied.

  • Because this is an administrative function, Planning assumes you have full access to data you copy. You are not prevented from copying to planning units that are approved.

  • This feature does not calculate data. To perform calculations, such as increasing the forecast by 5%, apply the business rule after copying data.

  • For Copy Data to be successful, you must select at least one member for Scenario, Account, Entity, Period, and Version dimensions.

  To copy data:

  1. Select Administration, then Manage, and then Copy Data.

  2. In Plan Type, select a plan type, and then click Go.

    You can copy from one plan type at a time. When you click Go, dimensions are displayed for this plan type.

  3. For Static Dimensions, enter the members for the data intersections:

    1. In Dimension, select a dimension from which to copy.

    2. In Members, click Member Selection to make a selection from which to copy. You can select multiple members. You must select at least one member for Scenario, Account, Entity, Period, and Version dimensions.

  4. Optional: To add another static dimension to the list, click Add Dimension and enter dimension members. (To remove a dimension, select None - Select a Dimension. The dimension moves to the Dimensions with Source and Destination area.)

  5. In Dimensions with Source and Destination, enter dimensions into which to copy data:

    1. In Source, click Member Selection

    2. In Destination, click Member Selection.

  6. In Copy Data Options, select the type of information to copy.

  7. Click Copy Data.

    Data is copied from one intersection to the other. If data is not copied successfully, a message is displayed. You can also check the log file.

  8. To copy data for another plan type, select another plan type in step 2, and repeat the procedure.

Tip:

To view the execution status of Copy Data, see “Checking Job Status” in the Working with Planning for Oracle Planning and Budgeting Cloud Service.