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

aggregation in cube

how can we avoid aggregation in a cube?i know that cube stores aggregated data ,has this aggregation got anything to do with the aggregation we find in query properties?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 11, 2012 at 04:03 PM

    Hi,

    An aggregate is a materialized, aggregated view of the data in an InfoCube. In an aggregate, the dataset of an InfoCube is saved redundantly and persistently in a consolidated form into the database.

    Aggregates make it possible to access InfoCube data quickly in Reporting. Aggregates serve, in a similar way to database indexes, to improve performance.

    We recommend that you create aggregates, especially in the following cases:

    The execution and navigation of query data leads to delays with a group of queries.

    You want to speed up the execution and navigation of a specific query.

    You often use attributes in queries.

    You want to speed up reporting with characteristic hierarchies by aggregating specific hierarchy levels.

    Check this link...

    http://wiki.sdn.sap.com/wiki/display/BI/Aggregates+--++SAP+BW+Query+Performance

    Regards,

    Aravind.

    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.