Why does drilling down take so long in JasperReport Server OLAP views?


I created an OLAP view in JasperReport Server. Everytime I drill down to a lower level, it takes 30 seconds to a couple minutes to load, but if I drill up and then drill down on the same dimension then it loads instantly. Since it shows all the summarized data first, doesn't it need the data from the lower levels to determine the summaraized data. I am not sure why it takes so long to drill down since it must already know the data from the lower level. Can anyone explain this or does anyone know a way to make drilling down faster?

jbreault's picture
Joined: May 8 2017 - 7:44am
Last seen: 2 days 39 min ago

1 Answer:


In general, adding more memory and getting faster CPU will make the drill down much faster.


hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 day 10 hours ago