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!

FX Impact for entire Organization (Top Entity Member)

646247Jun 20 2008 — edited Aug 19 2008

Everything has been done before. Does seen "best practice" related to the below situation:

What is the best way to see the total FX impact for the top member of an organization? We have a worldwide HFM application with over 40 differeny local currencies. What would be the best way of getting the FX impact for the entire organization. I.E. The aggregation of the each country's FX impact to the top member of the entity heirarchy (which is in USD).

I've seen one idea so far, but it meant adding more scenarios and touching the rules file (which I'm not so keen on doing since we've had a stable functioning environment for approx 1 year now). Is there any other way to do this?

I was thinking of accomplishing this all within a HFM Report. In other words, let Reports do the FX calculation rather than touching the rules file and adding additional scenarios to HFM to store the data.

All thoughts are appreciated.

Thanks - James

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2008

Added on Jun 20 2008

#business-intelligence-applications, #financial-consolidation, #performance-management-applications

4 comments

2,195 views