Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2007 at 06:44 PM

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

    Ravi Thothadri

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2007 at 09:06 PM

    Hi Dries,

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

    Add a 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

  • author's profile photo Former Member
    Former Member
    Posted on Aug 16, 2007 at 12:37 PM

    Hi,

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on 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 a 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.