Is Smartview drill exponentially slow vs. classic addin?
June 14 2012 at 10:40 PM No score for this post
from IP address 220.127.116.11
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 (18.104.22.168.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.