Loading FX Rates via Data Management
We are trying to load FX rates into FCCS Rates cube via DM and are running into issues. The data imports and exports fine but we do not see the rates loaded into the cube while checking from the Webform.
Below are the source file formats and the data loaded into workbench. USD and EUR are marked as reporting currencies. Below are the questions we have:
- Does the file format look correct? Period, Year, Rate Type, From Currency, To Currency, Amount
- At first DM was not recognizing the Column E from the source file in the "Data Load Mapping File" (see screenshot 3) and the export was failing with error "