Alternate Rate Translations

Summary:

I have a requirement to provide alternate translations for income statement and balance sheet data. So, for example, a user would like the ability to see Actual data translated at Actual FX rates and at Budget FX rates.

Ideally this would be achieved within the same scenario using members within a custom dimension.

For income statement and balance sheet flows I can achieve the desired result using Translation Override functionality however how can I achieve the correct result for balance sheet closing balances as the default FX calculation always seem to use the standard closing rate and so the FX calculation will always result in the closing balance being translated at the standard closing rate.