I have a parameter which is filled with a set of about 90.000 rows. When running the report, it takes a long time to view the report. While it loads the report the CPU on the client is getting up with 50% and the memory stacks 300 MB.
I think that I am doing something wrong as when I run the query directly at the cube, it takes just 9 seconds.
Does anybody have coped with this problem? If so, what are the best practices in this?
Your help will be greatly appreciated!
View Complete Post