cancel
Showing results for 
Search instead for 
Did you mean: 

improving performance of reporting

Former Member
0 Kudos

how can we improve the performance for reporting

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Try this to improve the performance for reporting:

1.Using 'For all entries' in the table makes internal reprocessing and reading of data fast.

2.Sort the table .

3.while using read statement use binary search.

4.Avoid using Select * in table that have a lot of fields.

5.Do not use nested select for large amount of data.

6.Using table buffering improves the performance.

7.Use the GET RUN TIME command to help evaluate performance.

8.Generally, try to reduce I/O first, then memory, then CPU activity.

9.Use as many table keys as possible in the WHERE part of your select statements.

10.Use the SELECT SINGLE command whenever possible.

11.Avoid dead-code

12.Remove unnecessary code and redundant processing .

13.If you want to find the maximum, minimum, sum and average value or the count of a database column, use a select list with aggregate functions instead of computing the aggregates within the program.

14.If you process your data only once, use a SELECT-ENDSELECT loop instead of collecting data in an internal table with SELECT ... INTO TABLE.

15.use WHILE instead of a DO+EXIT-construction. WHILE is easier to understand and faster to execute.

16.CASE statements are clearer and a little faster than IF-constructions.

17.Calling methods of global classes is faster than calling function modules .

18.We can use various Tools available in SAP for performance problem

The runtime analysis (SE30)

SQL Trace (ST05)

Tips and Tricks tool

The performance database

Answers (4)

Answers (4)

Former Member
0 Kudos

hai kishore,

to improve your query performance

1) reduce the usage of navigational attributes as possible

2) don't use no.of characteristics in report instead keep them in free characteristic

3) maintaining the aggregates will improve your performance

4) maintain the cube indexes without fail

Former Member
0 Kudos

Hope these links help u:

http://sapbibw2010.blogspot.com/2010/11/performance-issues-in-sap-bibw.html

http://wiki.sdn.sap.com/wiki/display/profile/BWsystemtuning

BI Accelerator is the first choice.If the client have BI Accelerator implemented. By Creating BIA indices we can improve Query Performance.

Yes, Aggregates wud generally enhance the perforemance of reports..Also see this:

http://help.sap.com/saphelp_nw04/helpdata/en/7d/eb683cc5e8ca68e10000000a114084/content.htm

Former Member
0 Kudos

hi..

yet another way is to use aggregates so as to accelerate the response time of queries, by reducing the amount of data that must be read in the database for a navigation step.

Former Member
0 Kudos

Couple of Recommendations.

Search on this forum for Performance Tuning. This question has been addressed many times on the forums. You will find plenty of pointers for performance tuning.

Here is a link to a SDN article on Performance tuning in SAP BI that i have used in the past.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5ee957e5-0201-0010-9c83-fe1...

Good Luck.

MP.