5 Replies Latest reply: Oct 18, 2013 5:06 AM by Evgeniy.Rasyuk RSS

    Calc Script is taking 20 min

    Sravan1011

      Hi Experts,

       

      We are having a Calc Script which used to run in 6 min, but after adding a alternative hierarchy for one of the Sparce Dim it is taking around 25min to run...

      can any one help me in optimizing the and reducing the calc time

       

      Block Size: same before and after adding alternative Hierarchy

      Verion: 11.1.2

      BSO Application (Not Planning App)

       

      Set cmds used

      SET UPDATECALC OFF;

      SET CACHE HIGH;

      SET CALCPARALLEL 4;

      SET CALCTASKDIMS 2;

      SET AGGMISSG ON ;

       

       

      Regards

      Sravan