We recently upgraded to EHP 2 SPS 8.
Once we upgraded, we see all the BEx queries on the system taking 3 or 4 times the time that it took previously before the upgrade.
We found that the Data manager time is not affected. We see 90% of the time being spent in OLAP.
Could someone give us directions to find the issue that is causing this performance problem and get it sorted ?
FIrstly please ensure that you are using the SAP GUI 7.20 front end with latest patches for the GUI and BEx.
Then please follow all of the recommendations in these 2 comprehensive WIKI articles for BEx performance.