Execute Bex query in background and save the file in FTP

[Former Member]

Hi All,

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.

Regards,

Shreeja

[former_member186445]

search SCN for 'broadcast'. should give you an idea on how to achieve this.

M.

[Former Member]

Hi,

Tried the broadcast option, but then we have the limit on size of the file..

We have huge data and it exceeds the maximum file size limit.

Regards,

Shreeja

[RafkeMagic]

who is going to "read" such a huge report?

maybe you should challenge your business/end users to have a more "manageable" report...

[Former Member]

Hi,

Users are very specific about the report layout & they do not want any of the fileds to be removed / moved to free characteristics also..

[former_member184494]

Use TCode RSCRM_BAPI to export tot a file on the server - but if your query has text values like descriptions - then RSCRM_BAPI will not work.

You might have to try APDs or Open Hub to achieve the same.