Calc script taking time
Summary
Calc script taking timeContent
Hi All,
I am using the below script for my calculations
when am using the range function Oct:Sep Inside Fix my script taking approx 30 mins to run. but if I place only one period instead of range i.e. march it will take 77 mins to run.
Pls differentiate both the scripts also advise why it is taking time when I am changing the range function into single period?
SET CACHE HIGH;
SET UPDATECALC OFF;
SET AGGMISSG ON;
SET CALCPARALLEL 3;
FIX(Oct:Sep,"YTGINPUT","3-month","6-month","9-month","12-month",&F_2016Year,
@member(@shiftsibling(&F_2016Year,1)),
1