Execute Bex query in background and save the file in FTP
I have a query on Infoset & there are 5 targets below that (3 DSO's & 2 IO)..
None of them can be removed.
Now the problem is there is severe performance issues with the queries.
Even for 400 odd pages, it gets timed out after 10 mins
We had requested Basis to increase the time out paramter.
Behaviour of the report
11 fields are readily available (In rows) in the report . The remaining fields, that need to be part of the report are available as ‘free characteristics”.
In order to generate the complete report required for fulfillment, each of the remaining output fields(free characteristics) needs to be added one by one .
Total estimated time for report = Time for generating report with 11 fields (5-10 Mins) + Time for adding each additional field (5 Mins appx *32 fields)= 170 Mins appx.
On a daily basis spending this much amount of time would be very inefficient..
Sometimes the first time we execute the report in query designer it gets timed out & the very next time its gets the output in 2mins (for a months data - 1500 odd pages).
Now, we are looking for some background jobs so that the report's data can be saved in some file and placed in FTP folder on a daily basis in order to avoid the waiting time for users.
Please suggest how to go ahead.