Skip to Content
avatar image
Former Member

BI IP - bad performance in BEX workbooks

Hi,

we use BI IP and have workbooks with 5 to sometimes 10 planqueries (located on individual worksheets). We notice that the performance in BEX is bad. The planning functions itself are performant ( less that 5 seconds in the modeler). However in the excell workbook everything is slow;

opening: 30 seconds - 3 minutes.

simple save: at least 30 seconds

planning function: more or less the same as the save.

=> when performing a trace with ST05 (when clicking on save for example) we don't see much happening. Also in SM50 we don't see much happening.

Does anyone has experienced the same (or the opposite?) Is this problem caused by SAP or by Microsoft Excell?? Are the figures above normal???

D

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Aug 16, 2007 at 06:44 PM

    Try to restrict the data by defining filters and use variables.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 09:06 PM

    Hi Dries,

    Do you, by chance, have any heavy characteristic relationships involved?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Gregor Dieckmann

      Hi Gregor,

      What would be acceptable is that my 10 queries are not updated automatically but only when the user would like to. But the "old result" (which could be the initial load for example) should always remain visible. With RESET_DATA_PROVIDER I presume the user will only activate the query he wants to plan for, while the others remain not visible. How do you see this?

      D

  • avatar image
    Former Member
    Aug 16, 2007 at 12:37 PM

    Hi,

    Change the query to suppress results, and check your performance again.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I'll try to do this tomorrow when I have access to the system. Did you had the same problem and was it solved by doing this?

      D

  • Sep 19, 2007 at 09:04 AM

    Hi Dries,

    How's your performance now? We're also working with the analyzer and I also have problems with performance. I'm still in development but the data set is so small the performance can't be bad. And I only have one query in the workbook. I also see, looking at SM50, that the planning functionalities are very fast, but the response in excel is slow.

    If you heard anything from SAP, could you post this?

    Thanks.

    J.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      we created aggregates which decreased the response time significantly. But even if we have no data or it is quickly selected, it takes for ex 10 - 20 seconds to do something (saving, simple function) in case of workbooks with 4 - 8 queries. For queries with one query, this is faster, like 3 - 8 seconds to do something.

      I think planning in BEX is slow (it is 4 - 20 times slower than web according to SAP studies!), but the effort we should do now to increase the speed would not weigh up against the benefits ...

      could you do a trace with ST05 and let me know which statements take the longest time? What is your reaction time in your query. How hearvy is your query? Do you have pictures or graphs included? do you use data slices or characteristic relationships? you can also email to further discuss.

      D