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

CALC ALL = Lazy

July 7 2009 at 9:32 AM
No score for this post
Anonymous 
from IP address 166.128.168.78


Response to CALC ALL increase by 30 min with each run.

CALC ALL is a real no-no in my opinion. I would recommend spending some time figuring out the bare minimum amount of calculations required to produce correct results. Your calc script should represent this bare minimum. Only calculate the dimensions that need calculating. If possible, don't calculate your dense dimensions at all (make calcs dynamic where possible). Fragmentation may still be an issue, however almost any amount of effort can improve on the results of a CALC ALL.

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

  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
  3.  

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.