You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Loading FX Rates via Data Management

Accepted answer
48
Views
5
Comments
edited Mar 2, 2022 2:06PM in Financial Consolidation and Close 5 comments


Summary:

Hi All,

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 "

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!