Skip to Content

BI7 Key Figure Performance

Hi,

when converting BW35 queries into BI7 queries we notice that the performance of the new BI7 query is getting worse.

Do you have any hints or tips how can analyse the performance issue (oss notes, method to check etc.)

thanks and regards,

Hans.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 26, 2009 at 08:33 PM

    Hi Hans,

    In RSRT/RSRT2 transaction select your query and then hit on Execute+Debug.

    Select Display Statistics data under others and hit continue. The query Selection will be displayed, enter selection and you will get results. After that hit Exit and you will get the Statistics, check where the query execution taking time and then you can investigate the reason.

    Regards,

    Kams

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 27, 2009 at 06:13 AM

    Hi

    From ST03N you will be able to view the time spent at each level i.e at OLAP, DB, Frontend, Planning, Unassigned. Or you can use the queries built on the Admin Cockpit cubes(0TCT_MC01, -2,03) to analyse the same.

    Follow the note 934848 and install the content and make the portal connection. Can monitor the system via portal.

    And also You can measure Query performance on the response time, which can be split into variable read time custom variable , DB fetch tme and OLAP time.

    Standard technical content queries can help you to get teh details; you need to activate technical content cubes for that. or you can access teh info from se16 by looking into RSDDSTAT* tables

    Hope this will help to you

    Thanks & Regards

    Kiran

    Add a comment
    10|10000 characters needed characters exceeded

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.