In what way is it not working?
I expect at Rule type Periodic, the translated value = Prior period Translated value + YTD change from period period * Translation Rate. which does not seem to be working.
however the for the Direct Rule type, the translated value = Current YTD Local value * Translation Rate . which works as expected.
What kind of Rule Type do you have assigned to the cube/scenario? And is the Translation algorithm on the cube "Custom" or "Standard using Business Rules"?
For the cube I have used Closing rate at Direct rule type. Scenario follows the cube Fx setting. And I am using standard using Business Rules in the cube translation algorithm setting.
