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