topic Re: Abap Program Optimisation tool in Application Development and Automation Discussions

Abap Program Optimisation tool

Former Member — Thu, 20 Dec 2012 17:15:17 GMT

Hello experts,

I am using in BW an Abap program in order to generate a csv file from a cube.

The more we have data in this cube, the generation time of those CSV files takes longer and longer.

I would like to optimize it, and i want to know if there is a tool in SAP which allows to see the parts of the program which take longer.

Thanks for your help.

Amine

Re: Abap Program Optimisation tool

hendrik_brandes — Thu, 20 Dec 2012 20:17:37 GMT

Hello Amine,

you can observe and trace your programs with the transaction SAT. There you can measure the runtime and depending on your variant, you can go up to the sql-statements to see where your program loss any performance.

But: In your case, I would think about using OpenHub. There you can create a CSV-File with data from any infoprovider you like to access. Even if your data does not fit exactly to your csv structure, you can use transformations to build a mapping to this.

Kind regards,

Hendrik

Re: Abap Program Optimisation tool

Former Member — Fri, 21 Dec 2012 14:52:33 GMT

Hi Hendrik,

Thanks a lot for your answer.

But for open hub, i think that we have to pay another licence to SAP in order to use it.

Amine

Re: Abap Program Optimisation tool

hendrik_brandes — Wed, 02 Jan 2013 17:51:03 GMT

Hello Amine,

you should be right: For OpenHub there is an additional license fee required. But most of my customers have them.

Do you still have your performance problems?

Kind regards,

Hendrik

Re: Abap Program Optimisation tool

Former Member — Wed, 02 Jan 2013 18:29:12 GMT

Hi Hendrik,

Happy new year and best wishes for 2013.

Thanks for asking, since i have many open subjects. I still working on....

Amine