Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Currency Translation Adjustment (CTA) in HFM

YohanaFeb 13 2012 — edited Oct 19 2012
Dear all,

I'm sure, all of you who has been implementing HFM knows about this CTA. I know how it calculates, I just curious, to which account this CTA normally calculated ? And just to make sure, HFM doesn't have a proper or pre-built calc for this CTA, right ? So, we have to develop our own.

Concerning this CTA on my application, I notice there are only several accounts impacted or requested by user to have a view of CTA. They are Capital, Non Controlling Interest. But when I read in one of HFM book, there might be some other accounts that can have an impact of this CTA. My first question is, how do I know which account will be impacted by CTA ? is that all account that using historical rate only ?

Still related to CTA, to handle this, I created a member called Translation Adjustment in custom dimension. I thought every account can have an impact for this CTA so i put it in Custom dimension. How do you guys handle this based on your experience ? Do you pull everything in one account as Translation Adjustment or do you create a custom dimension just like mine ?

Thanks,
- Anna
This post has been answered by KostasN. on Feb 13 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 16 2012
Added on Feb 13 2012
7 comments
6,539 views