Skip to Content

aggregates

Hi,

how to find list of aggregates which are never used

Rgds

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 22, 2011 at 09:58 AM

    Hi chamaluru,

    When the query is executed, it is clear to the user whether data is being read from an aggregate, a BI accelerator index, or an InfoCube.

    In the maintenance transaction, you can deactivate one or more aggregates on a temporary basis to test them for performance purposes or to analyze data consistency.

    You can also execute the relevant query in the query monitor (transaction RSRT) using a corresponding debug option: Choose Execute + Debug. In the Debug Options dialog box, choose Do Not Use Aggregates to execute the query with an InfoCube, as long as no BI accelerator index exists.

    Use the transaction RSRT to check the aggregate usage. Stats tables can also be used to find the usage of aggregates.

    Regards,

    rvc

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2011 at 04:46 AM

    Hi,

    enter t-code LISTCUBE ok.

    second thing is T-CODE:RSRT

    third one is :You just observe /select your cube& observe right side of your cube you can find sigma symbol that symbol explains you about which cube is maintain aggregate .

    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.