Skip to Main Content

Programming Languages & Frameworks

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Block creation issue for next year January

user-n53tiMay 26 2023

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

Comments
Post Details
Added on May 26 2023
1 comment
198 views