Hello experts,
I have an average balance calculation script as below
………………………………………………………………………………………………
IF(@ISMBR("P01") AND NOT @ISMBR(@MEMBERAT(@CHILDREN(Year), 1)))
"Average_Balance" = 0 + (("Closing_Balance" + "Closing_Balance"->"P12"->@MEMBER(@PREVSIBLING(@CURRMBR(Year)))) / 2);
………………………………………………………………………………………………
The script works fine, provided January Next year block should be already created. I have multiple years, so I cannot write datacopy for one year.
If I forcefully create a block everywhere, it will have performance implications.
Please suggest a solution for Essbase 21c OAC
Thanks,
Saket Kukde