How to increase performance of a report created using "Report Writer"?

[Former Member]

Hi,

In our production system we have some reports which are created using Report Writer. Their performance is very low.

How to increase performance of these reports?

I am new to report writer.

What should be my approach and how to analyse them?

TIA.

Pria.

[valter_oliveira]

Hello.

Try to change the access to database tables. Use primary or secondary indexes of the accesses if possible. If not, the performance will be bad.

Use tcode ST05 to analyse wich statement has low performance. Activate trace, use your report, deactivate trace and then analyse the poor select statements.

Regards.

Valter Oliveira.

[Former Member]

Hi,

Thanks for the quick response.

The program will be system generated . so how to change the code .

I analysed the report thru ST05.How to change the database access?

pria.

[valter_oliveira]

Hi again.

Yes, report writer will generate the code so you cannot change the code directly. However, you can see graphicaly, or at least by the fields you use, which is the database selection it will make.

ST05 will show you the worse selects it is doing, and that way you can try do get the data some other way. Post here the selection it does, and that way, probably someone can help you.

Regards.

Valter Oliveira.

[Former Member]

Reward Points..

[Former Member]

Hi,

to be honest there usually is not much to do I would say ...

...if you have already checked all possible in your report example

that users are not able to select huge amount of data with it,

if that is not really necessary (example if possible: report makes users to select only value at the time (not huge from to ranges),

you make user to select example only period at the time (not whole year or from to)...

...if big problems still with ReportWriter-report,

then I propose you create a good abap-report (executed in background...) and if problems also with that

- then report should be executed from somewhere else, example from BW/BI ....outside R3.

Hopefully you can solve this case 😃 BR Ann-Mari