Hello BW gurus....
I have a problem here. When a user tries to run a consolidated query it takes a long time. what are some of the performance tuning that can be done. My other issue is that once the query is run and the user tries to change the filter values say hes trying to restrict Cons group it takes like 30 min for the options to come up or even more than that and eventually fails. Is there any thing which i can do to improve the performance of these filter value selection option. we are on portal EP 6.0. I know this has nothing to do with interface but the crux of the problem is in the back end.
Any help is really appreciated