Copying Data

You can copy data from a Scenario, Year and Period to another Scenario, Year and Period. For example, during the close process, you may want to save a version of the tax provision for analytical purposes to compare further updates, or to possibly return to a previous version. You could also copy data from the Actual Scenario to the Forecast Scenario to populate a Forecast environment. You could copy data from the Actual GAAP Reporting Standard to the Stat Reporting Standard to populate those calculations.

  To copy data:

  1. Open the application, and select Consolidation, then Data, and then Manage.

  2. Define the Source: Select the Scenario, Year, and Period(s).

    You can only select one Scenario and one Year at a time. You can select multiple periods.

    Note:

    Make sure that you have selected the period where tax rates are entered.

  3. Define Copy Members: Select the Accounts and Entities.

    Select {[Base]} to include all members for Accounts and Entities; or using the Member Selector, you can select individual accounts and / or entities required.

    Note:

    Make sure that you have included Entity#[None] in order to copy tax automation rules and global FX rates (Entity-specific FX rates are copied based on the Entity selection).

  4. Define the Destination: Select the destination Scenario, Year and Period(s).

    You can only select one Scenario and one Year at a time. You can select multiple periods.

    Note:

    Make sure that you have selected the same period(s) as defined in the source above.

  5. From Options, select options for the copy data process:

    • Mode, select Replace to replace data in the destination scenario, or select Merge to overwrite data in the destination scenario.

    • Entity Currency Data - select to copy the data in the Entity Currency member of the Value dimension.

    • Cell Text - select to copy cell text data.

    • Optional: Select Enable Detailed Logging to create a log file to validate successful copy of data.

    • View - select YTD (Note: Always select YTD from the drop down list).

    • Rates and System Data - select to copy global FX rates and system data.

    • Copy Derived Data - do not select this option.

    • Multiplier - multiples the amount to be copied with the value that you enter. The default is 1.0.

  6. Click on the Copy Data button on the top right corner on the page to start the copy data process.

Depending on the amount of data, after the copy process completes, a summary dialog displays with the following details:

  • Copy data started and finished – date and time

  • Source and Destination – Scenario / Year / Period(s)

  • List of Entities and status of copy