Essbase YTD Currency Calculation
SummaryEssbase YTD Currency Calculation
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).
Jan MTD 100 @ .70 = 70 USD
Feb MTD 1,000 @ .80 = 800 USD
Feb YTD = 70 USD + 800 USD = 870 USD
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)