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."
Selecting Members
You must select members for Scenario, Year, Period, Entity, Data Source, and Consolidation.
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.
The "View - Periodic" member is fixed and not available for selection in the Copy Data process.
The Member Selection also allows you to use Substitution and User variables.
Data Source Members
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.
Consolidation Members
If you selected Regular Data for the type of data to be copied, Consolidation member selection is required.
For the Source member, you can select one or more of these members:
-
"FCCS_Entity Input" (default)
-
"FCCS_Parent Input" (if enabled in the application). If selected, you must specify the Parent.Child information in the Entity selection.
-
"FCCS_Contribution Input" (if enabled in the application). If selected, you must specify the Parent.Child information in the Entity selection.
-
"FCCS_Translated Currency Input" (if enabled in the application)
The Target member is always the same as the Source member, it cannot be redirected. In the Target column, the member is display-only and you cannot edit it.
Data is entered into "FCCS_Translated Currency Input" through journal posting, therefore the same process is applied as when you select the "Journal Input" member for Data Source. The source journal is copied to the destination with the proper POV as an unposted journal, then the journal is posted to the destination POV.
Currency Members
The Currency dimension is automatically set to the proper value based on the selected Consolidation member.
Table 5-6 Consolidation Member and Corresponding Currency Member
Consolidation Member | Default Currency Member |
---|---|
FCCS_Entity Input |
Entity Currency |
FCCS_Translated Currency Input |
Input currency as per Data Source selected |
FCCS_Parent Input |
Parent Currency |
FCCS_Contribution Input |
Parent Currency |
Copy Data Profile
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.
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: