You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase YTD Currency Calculation

Received Response
edited Aug 2, 2018 2:36AM in Essbase 10 comments


Essbase YTD Currency Calculation


Hi All,

I have a BSO essbase cube where we load periodic data.  We typically convert to USD using periodic currency translations (current month average rate x local amount - see periodic translation below).  We now have a need to do a YTD currency translation (similar to hs.trans in HFM) where the YTD local amount is translated at the YTD average rate (see YTD translation below).

Periodic Translation

Jan MTD 100 @ .70 = 70 USD

Feb MTD 1,000 @ .80 = 800 USD

Feb YTD = 70 USD + 800 USD = 870 USD

YTD Translation

Jan YTD 100 @ .70 = 70 USD

Feb YTD 1,100 @ .75 = 825 USD (so 755 USD (825 - 70) has to be calculated and loaded to Feb MTD)

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!