FX calculation in ASO
Anyone performed complex FX calculations in Essbase ASO cube using MDX? If yes can you please provide the guidelines and precautions to be taken while designing FX in ASO?
There is a need for various FX calculations like Actual@budget rate, Actual@prioryear rate etc...and we want to explore if we could perform these calculations in ASO instead of in BSO cube.
Your comments are appreciated.
Our current version for Essbase is 11.1.2.2.104 on Linux
Approximate user on the system about 150.
Thanks,
Avi