How to derive FCCS_Elimination values against different reporting currencies?
Summary:
There is an integration between FCCS to EPBCS to load all the elimination data. Data load rules filter contains "FCCS_Elimination" for consolidation dimension and Parent currency is being used. However, FCCS has multiple currencies with translations, and few accounts have been tagged with historical amounts overrides. Since, few parent entities in FCCS are EUR denominated, using parent currency expression gives values in Euros for children of such entities. However, EPBCS team is interested only in USD Values. FCCS team is trying to send data in "USD_Reporting" instead of parent currency, but it is unable to extract anything against USD_Reporting either in Data load rule or through smartview. The only work around now is to, perform translations in EPBCS. However, with Historical Override accounts, performing translation in EPBCS will not be straighforward.