Skip to Content
0
Former Member
Mar 31, 2010 at 08:06 AM

Slow performance on +11000 member dimension

35 Views

Hi,

We are using 7.5 NW at a customer site and have a request on a report generated based on a +11000 member dimension. The application is using 6 dimensions.

If a create a simple report with just one member on the column and only the topmember of my +11000 member dimension on row the performance is good.

My problem though is, I have to select all members in the dimension and use suppress=Y.

In this case the performance is slow (+ 2 min). If I delete the formatrange the performance is app. 1 min.

I know +11000 members is a big dimension, but is there any best practice on this area?

Is there any way I can solve the performance issue in my report?

Thanks,

Lars