Forum Discussion

Andy1's avatar
Andy1
New Contributor II
2 years ago

Assign ClosingRate FX Rates within a Cube View

We currently have a cube view built out to compare specific GL account values from quarter to quarter. Some of these values needs to be translated using using FX rates. We have AverageRate and Closin...
Cube View
Reports
MarkBird's avatar
MarkBird
Contributor III
2 years ago

Hi Andy

What type of accounts are these? Typically you would expect the accounts to translate based on their account type:

and the cube properties:

What is the purpose of the comparison cube view? Are you expecting the accounts to translate at closing rate in the cube view, and at average rate during consolidation?