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

Any ideas to improve Agg time?

October 29 2011 at 11:54 PM
No score for this post
Anonymous 
from IP address 198.169.189.227

I'm aggregating 4 sparse dimensions using the agg command ... Agg (A, B, C, D)
A is the biggest dimension with 30,000 members, B, C and D have 100 to 200 members.

I've the following settings in my calc ...

SET CACHE HIGH;
SET LOCKBLOCK HIGH;
SET CALCPARALLEL 6;
SET AGGMISSG ON;

The agg starts off quick but slows considerably as it progresses. Is there any way to make this faster? I've around 4Gig of Index cache and it's taking over 12 hours to calculate.

Any ideas will be appreciated.


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

  1. Re: Any ideas to improve Agg time? - Tim Faitsch on Oct 30, 7:47 AM
    1. Re: Any ideas to improve Agg time? - Anonymous on Oct 30, 9:35 AM
      1. Re: Any ideas to improve Agg time? - Tim Faitsch on Oct 30, 12:15 PM
        1. Re: Any ideas to improve Agg time? - Javier on Oct 30, 12:56 PM
          1. Runs with "Calculator Cache With Single Bitmap ..." - Anonymous on Oct 31, 12:53 PM
            1. Since we have two strings of this topic.... - John A. Booth on Oct 31, 1:04 PM
              1. This is the first time calc. - Anonymous on Oct 31, 1:23 PM
                1. CALCTASKDIMS - John A. Booth on Oct 31, 1:46 PM
                  1. I've tried it with different values for CALCTASKDIMS - Anonymous on Oct 31, 3:16 PM
                    1. PARCALCMULTIPLEBITMAPMEMOPT - John A. Booth on Oct 31, 5:00 PM
            2. Re: Runs with "Calculator Cache With Single Bitmap ..." - Tim Faitsch on Oct 31, 2:53 PM
              1. Yes, set to 200 MB - Anonymous on Oct 31, 3:17 PM
     
  2. How big a server? - Angie on Nov 1, 11:05 AM
  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.