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

RSDDSTAT rows and Multi-providers

We have a multi-provider that consists of 6 base cubes. When we debug a particular query in RSRT2 that uses 4 of the base cubes we see that sub-queries are spun off in parallel to fetch the results.

However, in RSDDSTAT table there are 4 entries. Three of them are all zeros in the key figure fields and one row is accurate information about one of the subqueries.

Is this a known bug in SAP BW? How can we find out which of the sub-queries is taking the most time in DBTIME?

Thanks, Peggy

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2005 at 04:15 PM

    The /nstad tcode won't have the SQL statement or explain plan.

    The best way to get that is in /nST05 -- the SQL trace tcode.

    Once you have captured and displayed the SQL Trace you can see the explain plan also.

    I usually take this 1 step further and analyze all the way down to the RDBMS level -- for example in Oracle, once I identify the bad SQL statement I'll turn on 10046 tracing to see the wait events, etc...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 04, 2005 at 04:23 AM

    Have you tried looking at the /nstad tcode? Each one of the queries stills generates statistics records. The STATS records has the breakdown of Processing and DB time...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your help. Can you help me find how can I tell which of the rows corresponds to which cube access?

      I turned on the Application information and was able to see the query name, but could not find details on the Sql statement?

      Thanks!

      Peggy

  • author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2005 at 06:07 PM

    Ok I understand the two pieces of the puzzle! Now what I am not following, is how to relate one particular "sub-query" that got spun off of the multi provider to the statistics I see in STAD?

    Help?

    Peggy

    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.