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

OLAP runtime very high - urgent

Hello Experts,

I am execting a query containing almost 30 RKF by hierarchy nodes and 30 CKF on those RKF.

Also, I am using Alt UOM in the KF conversions.

My ST03 analysis indicates that %OLAP runtime is approx 60% of total runtime.

I request you to suggest me few tips, which can considerably reduce OLAP runtime w/o removing RKF and CKF from query.

Should I use OLAP cache or not. What all settings I should apply in Query monitor (RSRT).

How do I test performance improvement.

What are the steps to set precalculation of reports, however this is the last option.

I read one of the blog from Prakash, he has suggested to inactivate OLAP cache when RKF and CKF are there in the query. Is it ok.

Thanks,

Swati

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2008 at 12:05 AM

    TIMEREAD and TIMEOLAP in rsddstat_dm and rsddstat_olap tables can be utilized to check the statistics.

    Note 557870 - FAQ: BW Query Performance

    Check if a high number of Cells transferred to the OLAP (use "All data" to get value "No. of Cells")

    a) Use RSRT technical Information to check if any extra OLAP-processing is necessary (Stock Query, Exception Aggregation, Calc. before Aggregation, Virtual Char. Key Figures, Attributes in Calculated Key Figs, Time-dependent Currency Translation) together with a high number of records transferred.

    b) Check if a user exit Usage is involved in the OLAP runtime?

    c) Check if large hierarchies are used and the entry hierarchy level is as deep as possible. This limits the levels of the hierarchy that must be processed.

    https://www.sdn.sap.com/sdn/developerareas/bi.sdn?page=bi_performance.htm

    performance-optimization-bi7-rsddstatolap

    Hope it Helps

    Chetan

    @CP..

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      If you want to precalculate workbooks, you need a precalculation server (this is an extra software program which should be installed on a server or a kick-ass PC).

      Basically what happens is that the workbook is calculated in the background, so the end-user is not bothered with waiting time.

      When the calculation is finished, the system can send a mail with the attached workbook, or post it on the portal in KM.

      Web templates/queries/reports can also be precalculated.

      Basically the same principle, except that you do not need the precalculation server software.

      OLAP cache can also be 'warmed-up', but I read that you switched it off for those queries, so that won't help you.

      There's excellent documentation about the broadcaster on help.sap.com, and on the forum.

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.