cancel
Showing results for 
Search instead for 
Did you mean: 

Reg : Poor BEx Query Performance.

Former Member
0 Kudos

Hello All,

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 ?

Regards,

Selva.

Accepted Solutions (1)

Accepted Solutions (1)

michael_devine
Active Contributor
0 Kudos

Hello,

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.

http://wiki.sdn.sap.com/wiki/display/BI/OptimizingBI7.0BExAnalyzerPerformance2012-Part1%28in+process%29

http://wiki.sdn.sap.com/wiki/display/BI/OptimizingBI7.0BExAnalyzerPerformance-2012-Part2-Statistic+Workbook

Regards,

Michael

Answers (0)