Need to optimize the calc script
Hello,
We have one clear calculation script which causes application abnormally shutdown and further causes illegal block header in database.
We checked the calc script and found that dense members Accounts and Begbalance using in FIX statement , ideally we should not use dense member in FIX statement (Dense member resides in every data block and while calculation, every block will come into memory , which can crash the database).
Please find below calc script:
SET CACHE High;
SET UPDATECALC OFF;
SET CALCPARALLEL 6;
SET LOCKBLOCK HIGH;
SET AGGMISSG OFF;
SET RUNTIMESUBVARS
{
yrname= "FY17";};
FIX( &yrname)
FIX("BegBalance", @IDESCENDANTS("Account"), "TARGETOP", @IDESCENDANTS("CostCenter")