All members and hierarchies need to be added to the data model.
A few system accounts are required to run the foreign currency conversion.
Member names with leading zeroes aren't supported, for example, 0001.
Accounts
These are the account members required for conversion:
| Account | Value |
| Translation Gain (Loss) | This is only required when using the Integrated Method. |
| Cumulative Translation Adjustment | This is required for the Current Method. |
| Cumulative Translation Adjustment – Current | This is required for the Current Method. |
| Cumulative Translation Adjustment - Group | This is required for the Current Method and only for European Consolidation customers. |
| Cumulative Translation Adjustment – Current - Group | This is required for the Current Method and only for European Consolidation customers. |
| Cumulative Translation Adjustment – Minority | This is required only when using the Non-Controlling Interest Consolidation Method. |
| Cumulative Translation Adjustment – Current - Minority | This is required only when using the Non-Controlling Interest Consolidation Method. |
Currency
The Currency dimension should have a hierarchy with all local and reporting currencies. Your provisioned system should already have an All Currency hierarchy. The only required change is to add or delete leaf currency members under the All Currency parent to add the local and reporting currencies required for your system.
DataView
Your provisioned system should already have an All_Values hierarchy with a Conversion member.
Movement
Your provisioned system should already have a Movement hierarchy with a CTA movement parent member with CTA_Opening and CTA_Flow as leaf members.
