This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

CALC ALL increase by 30 min with each run.

July 2 2009 at 3:59 PM
No score for this post		vp 
from IP address 192.231.130.1
The calc all for me was taking 2 hours. I changed the below most dense dimension to sparse.
and the calc all got reduced to 24 min.

However, if you run a calc all again, it goes to 70 min. On the 3rd run ... even above 110 min.

A defragmentation again brings the Calc all time back to 24 min.

Is there any way other than implementing defragmenation to keep the calc get finishing at 24 min.

Please advise if i'm missing something in my research.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Welcome to BSO World - Cameron Lackpour on Jul 2, 6:27 PM
    2.  
  2. Re: CALC ALL increase by 30 min with each run. - Anonymous on Jul 3, 2:20 AM
    3.  
  3. Agree with Cameron - Try Intelligent Calc - Angie on Jul 7, 8:49 AM
    1. Re: Agree with Cameron - Try Intelligent Calc - GlennS on Jul 7, 5:22 PM
     
  4. CALC ALL = Lazy - Anonymous on Jul 7, 9:32 AM
    1. Not necessarily true - ie 64 bit - Angie on Jul 7, 2:10 PM
      1. CALC ALL faster than calculating some of the blocks? - Cameron Lackpour on Jul 7, 2:39 PM
    2. Good Programmers = Lazy - Tim Faitsch on Jul 7, 2:24 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.