When trying to use the Calculate Rates option in the Currency section of the Data Warehouse Manager, the user gets the "Error in Calculating Rates" message in the image below.
This issue can occur when the code for the entity with memberid -1 is changed to something other that No Member. Most often this is changed to Null or NA.
To confirm that this is the problem, in SQL run 'select * from d_entity' on the Data Warehouse database. If code for entity with memberid -1 is anything other than NO MEMBER, edit the row to match the image below.
NOTE: Always make sure you take a backup of the database before making any changes.
Applies to: Data Warehouse Manager 4.x