How a copy historical rates process works

When you click Copy Rates, the target context and the target data area of TFINANC (FinCon Entity Balances) and TDETAIC (FinCon Entity Schedules) cubes are cleared.

The target data area is an area in which the DDATA value is Historical Exchange Rate.

The defined source context is used to retrieve the configured translation method from the Entity Parameter page. The value of the Translation Method column, for example, Method 1, is equal to the value of the corresponding Currency Method column on the Group Accounts page in Business Modeling. You can also view those values in the DACOUNT dimension in EPM Administration. With the copy process, a list of base accounts that use H, HI, HS, or HD currency method is retrieved. If no base accounts that use H, HI, HS, or HD currency method are found, the copy process is skipped.

The retrieved base accounts are used to retrieve and copy their historical rate values from the source context. The TFINANC cube is the source cube for the H and HI rates. For the HS and HD rates, the source cube is the TDETAIC cube.

For the target context with an Open status, historical rates are copied in this way:

H rates are copied to the corresponding accounts.
HI rates are copied to specific accounts per intercompany relationship.
If no Local Currency Balance values exist, HI rates are copied but the Total rate is not calculated. The value of the global 98 - System schedule detail is missing because the Total rate calculation was not performed.

If the Local Currency Balance values exist, rates are copied and the Total rate, Local Currency Balance, and Group Currency Balance are calculated. The value of the global 98 - System schedule detail is calculated too.
HS rates are copied to the relevant account schedules.
If no Local Currency Balance values exist, HS rates are copied but the Total rate is not calculated.

Note: *_NA rate is copied as is from the source context because there is no Local Currency Balance value in the target context.

The value of the global 98 - System schedule detail is missing because the Total rate calculation was not performed.

If the Local Currency Balance values exist, rates are copied and the Total rate, Local Currency Balance, and Group Currency Balance are calculated. *_NA rate is not copied but is calculated in the target context. For the formula, see "Calculations for historical rates”.
For HD rates, HS rates are copied to the relevant account schedules and HI rates are maintained within schedule details of designated accounts. In the copy process, the combination of HS and HI logic is used.
If no Local Currency Balance values exist, HD rates are copied but the Total rate is not calculated.

Note: *_NA rate is copied as is from the source context because there is no Local Currency Balance value in the target context.

The value of the global 98 - System schedule detail is missing because the Total rate calculation was not performed.

If the Local Currency Balance values exist, rates are copied and the Total rate, Local Currency Balance, and Group Currency Balance are calculated. *_NA rate is not copied but is calculated in the target context. For the formula, see "Calculations for historical rates”.