Skip to Content
author's profile photo Former Member
Former Member

Help required for improving performance of the Query

Hello SAP Techies,

I have MRP Query which shows Inventory projection by Calendar Year/Month wise.

There are 2 variables Plant and Material in free charateristics where it has been restricted by replacement of Query result .

Another query is Control M Query which is based on multiprovider. Multiprovider is created on 5 cubes.

The Query is taking 20 -15 Mins to get the result.

Due to replacement path by query result for the 2 variables first the control M Query is excuted. Business wanted to see all those materials in MRP query which are allocated to base plant hence they designed the query to use replacement Path by Query result. So it will get all the materials and plants from the control M query and will find the Invetory projection for the same selection in MRP query.

Is there any way I can improve the performance of the Query.

Query performance has been discussed innumerable times in the forums and there is a lot of information on the blogs and the WIKI - please search the forums before posting and if the existing posts do no answer your question satisfactorily then please raise a new post - else almost all the answers you get will be rehashed versions of previous posts ( and in most cases without attribution to the original author )

Edited by: Arun Varadarajan on Apr 19, 2011 9:23 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Posted on Mar 18, 2011 at 05:23 AM

    Hi,

    To improve the performance of query,

    -->Create aggregate on Cube, specially those info objects used in Query (Right Click on cube and maintain Aggregate)

    -->Compress the Cube data (in Manage, Collapse Tab)

    -->Check the Property of Query in RSRT( which is good for your query)

    Best Regards

    Obaid

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 18, 2011 at 06:18 AM

    Hi,

    U can improve at Objects side as by Aggregation and compression but at Reporting side following can be done

    1.Within structures, make sure the filter order exists with the highest level filter first.

    2. Check code for all exit variables used in a report.

    3. Move Time restrictions to a global filter whenever possible.

    4.If Alternative UOM solution is used, turn off query cache

    5.Check Sequential vs Parallel read on Multiproviders.

    6. Turn off warning messages on queries.

    7. Check to see if performance improves by removing text display (Use ABAPer to test and validate that this ensures better code).

    8. Check to see where currency conversions are happening if they are used.

    9. Check aggregation and exception aggregation on calculated key figures. Before aggregation is generally slower and should not be used unless explicitly needed.

    10. Avoid Cell Editor use if at all possible.

    11. Make sure queries are regenerated in production using RSRT after changes to statistics, consistency changes, or aggregates.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 05, 2011 at 04:45 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 06, 2011 at 05:06 AM

    Hi Vaishali,

    Caching improves performance for queries whose evaluation is more complex. It is recommended that you keep complex data processed by the OLAP processor in the cache.

    Please visit this link to get more details on the same :

    "http://raj-bi.blogspot.com/2010/10/summary-of-bi-70-performance.html ".

    Regards,

    Sarika

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 06, 2011 at 05:08 AM

    Hi Vaishali,

    Caching improves performance for queries whose evaluation is more complex. It is recommended that you keep complex data processed by the OLAP processor in the cache.

    Please visit the following link to get more details on the same :

    "http://raj-bi.blogspot.com/2010/10/summary-of-bi-70-performance.html"

    Regards,

    Sarika

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 18, 2011 at 01:28 PM

    In almost every case I have been inolved with it's the actual system specification, sizing and set-up that's at fault. Once those issue are fixed queries run quicky even when complex like yours.

    All the other tips here are what I would call "tuning", that only marginally improve performance in themselves. But if your queries are running on an underpowered system no amount of "tuning" will help.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      Please see if you can make these changes currently to the report . It will help in improving the performance of the query

      1. Select the right read mode.

      Reading data during navigation minimizes the impact on

      the application server resources because only data that

      the user requires will be retrieved.

      2. Leverage filters as much as possible. Using filters contributes to

      reducing the number of database reads and the size of the result set,

      hereby significantly improving query runtimes.

      Filters are especially valuable when associated with u201Cbig

      dimensionsu201D where there is a large number of characteristics such as

      customers and document numbers.

      3. Reduce RKFs in the query to as few as possible. Also, define

      calculated & RKFs on the Infoprovider level instead of locally within the query.

      Regards

      Garima

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.