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

Is Smartview drill exponentially slow vs. classic addin?

June 14 2012 at 10:40 PM
No score for this post
Rob Vicker 
from IP address 50.80.23.209

I have an ASO cube that has 11 dimensions. I have an excel grid with 36 columns that I am trying to drill to the bottom of four dimensions with suppression on is Smart View (users want to be able to find all new members added to the dimensions since last month).

Using the classic add-in it is extremely fast (.71 seconds, 3.61 seconds, 11.27 seconds, 35.65 seconds).

Using smartview the first drill is ok at about 7 seconds but it gets exponentially slower from there. The second drill takes a few minutes and the third churns for about 10 minutes and then the aps weblogic app runs out of the 6 Gig of memory that has been allocated to it (11.1.2.1.102 64-bit OS) and crashes.

So am I doing something wrong or is Smartview just that slow? I look in the Essbase app log and the retrieve completes in a matter of seconds but then it takes minutes to render in excel via aps (and then crashes).

Are the only options for this to either use the classic add-in or go to some other product like Dodeca?

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

  1. Dodeca is faster - Cameron Lackpour on Jun 15, 2012, 11:24 AM
    1. Fan of Dodeca here also. - Rob Vicker on Jun 15, 2012, 11:59 AM
      1. Hoping Oracle is aware about that... - sroux on Jun 16, 2012, 2:51 PM
    2. Re: Dodeca is faster - pieeater on Jun 18, 2012, 2:19 PM
      1. Re: Dodeca is faster - Tim Tow on Jun 20, 2012, 12:35 PM
     
  2. Open an SR. - Matt Milella on Jun 17, 2012, 8:35 PM
    1. Will do on the SR...Thanks (EOM) - Rob Vicker on Jun 18, 2012, 9:29 AM
     
  3. Another Dodeca fan - SteveL on Jun 18, 2012, 11:12 AM
    1. Re: Another Dodeca fan - GlennS on Jun 18, 2012, 2:31 PM
      1. Re: Another Dodeca fan - Tim Tow on Jun 20, 2012, 12:34 PM
        1. Re: Another Dodeca fan - GlennS on Jun 20, 2012, 3:20 PM
          1. My Results - Jeff McAhren on Jun 20, 2012, 4:13 PM
        2. Repeat member suppression was the fix. - Rob Vicker on Jun 20, 2012, 4:50 PM
          1. Re: Repeat member suppression was the fix. - Tim Tow on Jun 21, 2012, 11:29 AM
            1. Re: Repeat member suppression was the fix. - Jeff McAhren on Jun 21, 2012, 11:52 AM
            2. Ran A Zoom-Off of classic vs. Smart View - Rob Vicker on Jun 21, 2012, 12:30 PM
              1. Re: Ran A Zoom-Off of classic vs. Smart View - Jeff McAhren on Jun 21, 2012, 1:29 PM
                1. I was wrong...it was GZIP Compression that fixed it. - Rob Vicker on Jun 21, 2012, 4:39 PM
                  1. Re: I was wrong...it was GZIP Compression that fixed it. - Jeff McAhren on Jun 21, 2012, 6:19 PM
                    1. Re: I was wrong...it was GZIP Compression that fixed it. - Rob Vicker on Jun 21, 2012, 10:32 PM
                      1. join.me - Jeff McAhren on Jun 21, 2012, 11:34 PM
                  2. Re: I was wrong...it was GZIP Compression that fixed it. - Tim Tow on Jun 21, 2012, 7:31 PM
                    1. Re: I was wrong...it was GZIP Compression that fixed it. - Rob Vicker on Jun 21, 2012, 10:27 PM
                      1. Re: I was wrong...it was GZIP Compression that fixed it. - Tim Tow on Jun 25, 2012, 12:50 AM
                        1. Re: I was wrong...it was GZIP Compression that fixed it. - Rob vicker on Jul 2, 2012, 9:33 AM
                          1. Re: I was wrong...it was GZIP Compression that fixed it. - Robb Salzmann on Jul 2, 2012, 10:30 AM
                            1. Re: I was wrong...it was GZIP Compression that fixed it. - Rob Vicker on Jul 2, 2012, 11:00 AM
                  3. Nice post to save and archive - sroux on Jul 4, 2012, 9:49 AM
     

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.