Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Abap Program Optimisation tool

Former Member
0 Likes
612

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

1 ACCEPTED SOLUTION
Read only

hendrik_brandes
Contributor
0 Likes
566

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

4 REPLIES 4
Read only

hendrik_brandes
Contributor
0 Likes
567

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

Read only

0 Likes
566

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

Read only

0 Likes
566

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

Read only

0 Likes
566

Hi Hendrik,

Happy new year and best wishes for 2013.

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

Amine