‎2012 Dec 20 5:15 PM
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
‎2012 Dec 20 8:17 PM
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
‎2012 Dec 20 8:17 PM
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
‎2012 Dec 21 2:52 PM
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
‎2013 Jan 02 5:51 PM
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
‎2013 Jan 02 6:29 PM
Hi Hendrik,
Happy new year and best wishes for 2013.
Thanks for asking, since i have many open subjects. I still working on....
Amine