Forum Discussion

sandeepr's avatar
sandeepr
New Contributor II
2 years ago

Auto translate Currencies option on Entity.

HI All,

Good morning.

Could you please share the documentation on 'Auto translate Currencies option' in entity properties. 

Also, how it works in below mentioned scenario.

Scenario:  I have parent A and Children B both are tagged with Default currency 'CAD', but I want to translate Base and parent to USD in this case can I set Auto translate Currencies option to USD to convert data to USD without changing Parent A default currency to USD.

Thanks in Advance.

 

Thanks,
Sandeep

 

FX Rates
  • MikeG's avatar
    MikeG
    Contributor III
    2 years ago

    Hi sandeepr if you add that extra currency to the base member, there will be a nominal impact to consolidation time.  OneStream will translate and store that translated amount in that currency.  It adds to the number of stored data cells, but it also on the flip side, improves reporting performance.  The only 'gotcha' I've come across is with significantly LARGE data sets.  But the feature works and I'd suggest enabling it and checking before/after times for running a Force Consolidate on a full year of data.

     

    Also, you can have more than 1 currency in that field (for Auto Translate).  It's not limited to just one.  If it doesn't blow up performance on the consolidation time, I'd say it is a benign (low impact) change that will improve reporting.

    Hope this helps,