cancel
Showing results for 
Search instead for 
Did you mean: 

Query execution time

Former Member
0 Kudos

Dear SCN,

I am new to BOBJ Environment. I have created a webi report on top of bex query by using BISC connection. Bex query is build for Vendor Ageing Analysis. My bex query will take very less time to execute the report (max 1 min). But in case of webi is takeing around 5 min when i click on refresh. I have not used any conditions,filters,restrictions are done at webi level all are done at bex level only.

Please let me know techniques to optimize the query execution time in webi. Currently we are in BO 4.0.

Regards,

PRK

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Praveen,

Check below document.

~Anuj

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Praveen

Go through this document for performance optimization using BICS connection

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0e3c552-e419-3010-1298-b32e6210b...

former_member202257
Contributor
0 Kudos

Hello,

Please find the document on inputs for performance improvement-