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

after creation of aggregates , how do we know that aggregate working proper

best cases for creating aggregates

aggregates advantages

Please search the forum before posting a thread

Edited by: Pravender on Feb 4, 2012 10:59 AM

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2012 at 06:30 PM

    Hi,

    If you created and filled aggregates, but are unsure as to whether it makes sense to have a

    particular aggregate, then you can switch off the aggregate in the aggregate maintenance

    (select aggregate: Aggregate > Switch On/Off). With aggregates that are switched off you see

    a gray light in place of a green one. The effect of this is that the aggregate is no longer used

    by queries. Aggregates that are switched off, however, are still kept consistent. They can thus

    be used again directly as and when they are switched back on again. The advantage over

    deactivating or deleting is that the aggregate must not be refilled again, and switching off is

    thus particularly well suited to simple testing. As described in the previous section, you can

    now execute a query or trace which would really use the aggregate. Compare the time that is

    required by the database to the time that is required by the query using the aggregate. If the

    query is not considerably slower then you can deactivate or delete the aggregate.

    Please go through below document

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/cbd2d390-0201-0010-8eab-a8a9269a23c2?QuickLink=index&overridelayout=true

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 03, 2012 at 07:06 PM

    Hi

    You check the performance by running the query again. below link will give all the performance improvements need to take care in BI system

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

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 04, 2012 at 02:54 AM

    try to execute the query in RSRT..

    see

    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.