Copying Data

You can copy data from a source POV to a target POV to assist with your business planning and analysis. You can copy specific Scenario, Year, Period, and Entity dimension members to target dimension members. This enables you to perform a bulk copy of data along with the supporting details such as journals and Supplemental Data Manager details. For example, you can copy Actual data into a Budget or Forecast scenario to start your planning process. You can copy data from one or more periods, from one scenario to another, and from one or more entities. You cannot copy data to a locked entity.

To copy data, you must be a Service Administrator with Write access to the data.

You can copy these types of data:

  • Regular Data (including journals)

  • Override Data— rates and amounts entered on the Override Rates form for historical rate override accounts

  • Rate Data— data for global currency rates

For Regular data, you can specify whether to merge or replace the data during the copy process. You select Merge to add the source data set to the target data set, or Replace to replace the target data set with the Source data set. If you select Replace, data that does not exist in the source data set is cleared in the target. For example, if the Sales account for January does not have data in the source data set, then existing data in Sales for January will be cleared in the target data set. You can copy data to level 0 Target members only.

You can include journal detail in the copy process for Regular Data if you select a journal Data Source member. When you copy data that includes posted journals, the system creates the journal in the target POV and automatically posts the journal.

When copying journal data, all the accounts that are referenced in the journals must be selected in the Account dimension filter. If not, the journal creation will fail with this error message "Journal Posting for the Label: xxxxx is Failed: Journal is not balanced by currency xxx."

You must select members for Scenario, Year, Period, Entity, and Data Source.

You can optionally select members for the Account, Movement, Intercompany, Multi-GAAP and Custom dimensions. If you do not select members for these dimensions, all level 0 members are included.

Note that the Member Selection also allows you to use Substitution and User variables.

For the Data Source dimension, the target member is always the same as the source member; it cannot be redirected. An exception is the Supplemental Data member. The Supplemental Data member allows drill through from the summarized data in Financial Consolidation and Close to the underlying detail in Supplemental Data Manager. Because the underlying detail is not copied from the source to the target POV during the Copy process, and therefore is not available for drill through, when you select Supplemental Data as a source, you must select a target member other than Supplemental Data to store the copied value. The member that you select as a target for Supplemental Data cannot also be selected as a source.

After you select members for the Copy Data process, you can save them as a Copy Data Profile. This enables you to later retrieve the information for the Copy Data process without needing to make member selections again. See Using Copy Data Profiles.

The following members in these dimensions are fixed and not available for selection in the Copy process:

  • View - Periodic

  • Currency - Entity Currency

  • Consolidation - Entity Input

After the Copy process, the Calculation Status for all target entity data changes to Impacted. You must run consolidation to update the values.

The system does not include entities with NoData as part of the Copy process.

To copy data:

  1. On the Home page, click Application.
  2. Click Overview, then from Actions, select Copy Data.
  3. Select the items that you want to copy:
    • If you previously saved your Copy Data member selections as a profile, the Copy Data Profiles list displays the available profiles. You can select a profile, update it if need be, or click Run to run the saved Copy Profile.

    • If you do not have any saved Copy Data Profiles, select the type of data, and specify the Source and Target members.

  4. Select the type of data to copy:
    • Regular Data
    • Override Data
    • Rate Data
  5. For Regular Data, from Copy Options, select an option:
    This option is only available for Regular Data. Rate Data and Override Data are always copied using Replace mode.
    • Replace—All target data cells are replaced by the source data cell values.
    • Merge—The source data cell values are merged into the target data cell values. Any existing target data cells that are not part of the source copy will remain after the merge.
  6. For Source, select the members to copy, and click OK.
    If you copy a range of periods, the number of source periods must equal the number of target periods. Only Input base members below "FCCS_Total Data Source" are available for selection.
    If you copy Rate Data, you do not need to select any Entity members.
  7. Optional: To copy Supplemental Detail, select one or more Supplemental Detail Data Source members to copy, then from Supplemental Data Member, select a base Data Source member other than Supplemental Data for the target. The member selected as a target for Supplemental Data cannot also be selected as a source.
  8. For Target, select the members to which to copy data.
  9. Click Run to submit the Copy Data task, and at the prompt, click Yes to continue.
    The system displays a message that the Copy Data task is submitted. You can monitor the task status from the Jobs console. From the Application page, click Jobs, and then click on the job for more details.