This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Re: FX Calculations

April 24 2012 at 2:49 PM
No score for this post
from IP address

Response to NONEMPTYMEMBER in ASO within CASE Statements

This sounds like you are computing the gains and losses on changes in currency exchange rates and you are sometimes using eom values and somtimes mid month values. Right?

My first two questions are is this calc in the accounts dimension? And is the accounts dimension a dynamic or a stored hierarchy. If your answer is not that it is prinicpally a stored hierarchy that will be the key to your fix.

Reply with the answers and the hierarchy.

Is this by any chance a daily database?

Scoring disabled. You must be logged in to score posts.Respond to this message   

  1. Re: FX Calculations - Anonymous on Apr 24, 2012, 4:39 PM
    1. Fx usually means ... - Danp on Apr 24, 2012, 6:44 PM
      1. Fx usually means ... - Anonymous on Apr 25, 2012, 4:50 AM
        1. YTD should not be formula - DanP on Apr 26, 2012, 1:02 PM

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.