Block Creation taking longer
Hello All,
I have a calculation script in essbase where I am trying to create blocks . the below calculation takes 4 mins to run
Current scenario
SET UPDATECALC OFF;
SET AGGMISSG ON;
SET EMPTYMEMBERSETS ON;
/*SET FRMLRTDYNAMIC OFF;*/
SET CACHE HIGH;
FIX( 1 dense member (acc), period(dense), @DESCEndants(sparse dim 1 = 1 member)
FIX(@DESCEndants(sparse dim 1 = 10 member) @DESCEndants(sparse dim 1 = 50 member) @DESCEndants(sparse dim 1 = 500 member))
FIXparallel ("sparse" = 200 member)
"sparse member"
if conditions
Change : With the below change the calcukation takes 30 mins or more. I understand that there are more members to create blocks but this seems to take a lot longer than expected.