Forum Discussion
Solved
Alternative currency overrides aggregation
How do you consolidate currency overrides using alternative currencies e.g. Base Entity and immediate parent are in EUR and ultimate parent is in USD. Client wants to view consolidated view of immedi...
This is generally handled by having all parents in USD in the main hierarchy. This way, the base entities are translated to USD - they take into consideration all USD overrides. Then alternate hierarchies are used to view parents in other currencies.
chul
OneStream Employee
OneStream EmployeeBe aware that Auto Translation Currencies does not consolidate (and also adds time to your consolidation). So if you look at your immediate EUR parent in USD, it will translate the parent values to USD rather than consolidating the USD amounts from the children.
That's correct. It's definitely flawed. But it's also useful, especially if it avoids having to maintain (and consolidate) two different structures. As in all implementations, there are multiple approaches with multiple pros and cons.