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

Aggregates

1. Can we create aggregates on Hierarchy ?

2. Can we compress the data in aggregates/ will the data in aggregates are compressed?

3. What is the Thumb rule of aggregates?

4. By creating aggregates how much percentage increase query performance ?

5. How to find which aggregates are more usage &which are less usage?

6. How to find which aggregates are in regular usage?

7. Aggr are created on char info object but how to find out based on which char we need to create?

Please explain me in a Detail manner.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 09:03 AM

    1. yes you can use hierarchy level for creating aggregates in your cube.

    2. yes, you have the option "roll and compress" in roll on tab.

    3. * Do not create useless aggregates, because they are real cubes and contain data on your database.

    • Make use of aggregate hierarchy for performance.

    • observe your aggregations, fill and usage rates.

    4. 5. 6.It all depends on your queries and aggregation definitions, and data volume. right click on your infocube and choose "maintain aggregates" .

    there you can find, some statistical data about your aggregates. It shows how many records are aggregated to how many records in your aggregate.

    This can be the basic start point to evaluate your aggregate. If you have 10000 records in your cube, and 8000 records in your aggregate, this would not be very helpfull.

    Moreover, lets assume you have a good rate for aggregation of data, this may not still be a good aggregate if it is not used. ( usage time ).

    All the filed agrgegates are used by OLAP, unless you switch them off for queries.

    for a specific query, you can use debug option in RSRT to see if any aggregates are used during query run.

    7. you can make use of statistical data (by proposals). Also check sql definition of your queries that has bad performance.

    on maintain aggregates screen, choose "propose -->propose from query" steps.

    Hope this helps.

    Derya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 12:05 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 28, 2008 at 02:08 PM

    Thanks for your answers.

    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.