Dear Community,
I have Oracle Hyperion Planning 11.1.2.4 with updated patch 900, I have Data Form and a Calc Script associated with this checked option "Run on Save". In the calc script I'm doing same calculation based on FY,I'm using a substitution Var for FY in calc script. I have 20 members in Year Dimension, in the data form every time a year will change from LOV in the Page section then I have to change that substitution Var value, in this process end user depends on technical person.
The requirement is that I want to know a script or any Essbase function which can calculate current FY selected in page section of the data form, please tell me if there is any way to do that so, I can fulfill the satisfy them.
Thanks & Regards
Ismail Junaijo