The data copy feature enables the transfer of information from one context to another, provided that the aggregation types of the source and destination contexts are compatible, allowing not only copying but also the application of operations and formulas during the data transfer.
To use this tool, the user must have the following Manager Features enabled in Permissions:
It is also necessary to enable the Preview Feature:
- It enables copying data between contexts that share the same aggregation structure, ensuring that operations are performed accurately.
- The system allows the inclusion of operations on the data during transfer, such as addition, subtraction, percentages, and the application of formulas, which can be performed during the copy process or afterward, allowing for specific adjustments.
To use scenario copying, follow these steps:
1. In the T6 main menu, expand the Analysis section;
2. In the Analysis section, select the Data Copy option;
- When we click on Data Copy, a new window will open;
- In the initial step, through a dropdown we will select the Application in which we will work;
- After selecting the Application, the source and destination dimensions will be displayed based on the selected application;
Data Copy - Main screen.
- Source: Location where we will define the scope of members whose data will be copied;
- Destination: Location where the data copied from the source will be stored;
- Operator: Location where we can perform addition or reduction of copied values, whether through addition (+n), subtraction (-n) or percentage (+n% | -n%). To use the original values, just keep the equal sign (=).
We will necessarily need to select the same number of members in the source and destination dimensions;
- To select the members of a dimension, click on the pencil icon next to the dimension name, the same should be done for both the source dimension and the destination dimension;
If you have selected members in a source dimension, the same dimension in the destination must have members selected;
It is necessary to select at least one member from the Scenario dimension and one member from another dimension.
- We also have an Execute formulas switch button that when enabled will execute existing formulas in the application during the copy process, thus bringing values affected by execution;
- When we click Apply, a verification will be performed on the scope of the members. If inconsistencies are detected, we will be prevented from proceeding and there will be messages informing the reason for the impediment:
Impediment messages in Data Copy.
- Adjust the scope to follow the necessary requirements and click Apply. If everything is correct, the page will be closed and a notification will be generated, informing about the success in copying the data.
Data Copy - Success notification.
We can view the result through Forms in T6.
We can perform data copying directly through a form. To do this, we will open the form, select the Tools tab, in the data section, we will click on
. The Data Copy panel will open on the side:
Data Copy - Access through form.
In the opened panel, we will select the source of the data to be copied, select the pages where the data is located (filling will depend on the configuration set in the form).
We also have the Pages panel where we will select the pages where the data will be copied (according to the form configuration). This is our destination. We need to select the cells where we want the data to be copied. We can copy data across the entire form, in a column or row, by dragging the selector as needed, or by selecting specific cells, depending on the user's needs.
In the example below, the pages configured in the form are Scenario, Entity, and Time:
Data Copy - Page selection in form.
To perform the copy, click on
in the Data Copy panel. To complete the data copy in the form, click save in the Home tab.
If the type of data allocated in the source cells is not compatible with the type of data in the destination cells, the system will allow the data to be copied but will not allow the form to be saved.
To apply data copy through forms, follow these steps:
- Select a form and open it;
- Open the pages panel on the right side and select the destination page where the data will be pasted;
- In the Tools tab, in the data section, select the Data Copy option;
- In the data copy panel, select the source of the data to be copied;
- In the form, select the cells that will receive the data by dragging the mouse cursor to the desired selection area;
- In the data copy panel, click Copy;
- In the Home tab, click Save.