FDMEE to Essbase - calcscript parameters
Hi all,
Our FDMEE to Essbase data load process runs an Essbase script that clears data in those cells that are goingto receive new data. We are passing a series of runtime subvars to the script, one of them being the current year (CurrYr).
Global period mappings in FDMEE use the "FYXX" pattern for Year Target (FY17, FY18, FY19...), but years in the target Essbase app have been created as "2017", "2018", "2019", etc. Therefore, the application's period mapping have been adjusted accordingly, so the Target Year field has 2017, 2018, 2019... as target years.
In 2 out of 3 environments we have this is working perfectly fine. When the process is launched the log shows that the CurrYr subvar took the appropriate value (i.e. "2019"), but in one of the environment FMDEE kind of decides it must pass the year in the "FYXX" format, so the process errors out when Essbase tries to execute the calc with the CurrYr subvar set to "FY19", as the FY19 member does not exist in the target app outline.