Performance Issues with Webi Reports
Recently we upgraded from BOXI r 3.1 FP 1.3 to BOXI r3.1 SP4 and we ve been hit with major performance problems with respect to our webi reports. Reports which used to refresh within 10 minutes are now taking 40 minutes and eventually time out.We have maintained the same configuration parameters at the Universe level and CMS servers level. We have had the DBA review and perform sql tuning and indexing as well. But still the same. Also we had migrated around 200+ reports from the old environment to new environment. Could it be that there might be compatibility issues with objects and other custom variables created from one version to another version?
Any tips on how to improve performance would be very helpful.