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

HI gurus

Hi,

I have 5 aggregates on a cube,

1)how could i know what are the aggregates that are being used by a query.

2)And apart from this how could i know what is the time(Start and end time) taken by a query to execute..will any one please give me a detailed information regarding this.

3)I ran a query in RSRT,i have some options over there like display aggreagets found and select aggregats.

what are the major differences between these two options..

is it like 'display aggreagets found' is for the aggregates which are hit by a query are the available aggregats that are found.

and what is purpose of select aggregate.

Thanks in advance.

Shashikanth.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2006 at 06:27 PM

    Hi,

    For the aggregates that are used, you can goto aggregate maintenance screen and see which aggregates were used by looking at the stats on the right hand side columns.

    You can use BW stats or the technical content to see the start and execute times of the query.

    Check the link below for all the details related to aggregates:

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3f66ba90-0201-0010-ac8d-b61d8fd9abe9

    Cheers,

    Kedar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2006 at 06:02 PM

    Select option actually uses the aggregates when query is executed.

    You could use option Display Statistics to see runtime of query as well as additional technical information.

    You can also use BW Statistics to analyse performance in more detail.

    Hope it helps,

    Farhan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2006 at 07:22 PM

    Here are the answers:

    1. Got to RSRT for intial aggregates. for drill-down go to RSRTRACE and RSRCATTTRACE

    2. Got table RSDDSTAT table for details time of query execution.

    3. In RSRT the display aggr found will actually display the aggregate name ex: 100254 which was hitting by report but select aggregates..would be you can use it but the aggr. will be used in background...but I think if u choose select aggregates...the display aggr found would also gets checked.

    Hope this helps.

    BK

    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.