BICS Performance Issues
I few webi reports on BEX query using BICS connectivity, Once the reports and bex query are promoted to higher environment (Q) the reports are running very slow (5X slow), the prompt screen takes very long to pop up and reports take forever to run.
To test this out I have switched the connection in BO (dev) to point the Q and I find that every time my business objects reports are connected to one particular BW environment(Q) its very slow to execute the report, the date volumes and query executions are same in both BW environments.
Is there any setting in BW which controls the execution time/packet size/delivery times or anything? any suggestions?
I am on BO 4.1 SP4 patch2 and BW on HANA 7.3 SP9