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 immediate parent in USD including the currency overrides. The same reverse is required for USD entity rolling up to EUR. We have created alternate flow members but the aggregation is a challenge.
Solved! Go to Solution.
Unless I'm not understanding the question correctly, there is a field called Auto Translation Currencies in the entity dimension. You could have an EUR entity tree to an EUR parent, but put USD in the Auto Translation Currencies field. Of course if you are using dollar overrides in the equity section, this could potentially get complicated, but you can test for the currency member in rules.
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.