Skip to Content
avatar image
Former Member

Query execution time

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

Untitled.png (114.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 10, 2014 at 06:53 AM

    Hi Praveen,

    Check below document.

    Performance Tuning of BO reports

    ~Anuj

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2014 at 09:55 AM

    Hello,

    Please find the document on inputs for performance improvement- Performance Tips: Getting the most out of your Web Intelligence Processing Servers

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2014 at 02:03 PM

    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-b32e6210b58d?QuickLink=index&…

    Add comment
    10|10000 characters needed characters exceeded