What are Aggregates? Why do we need Aggregates

Free Download Udemy What are Aggregates? Why do we need Aggregates. With the help of this course you can Step-by-step creation of Aggregates? Why do we need Aggregates & what is its use.

This course was created by KUNCHAM Software Solutions Pvt Ltd. It was rated 4.8 out of 5 by approx 13400 ratings. There are approx 18605 users enrolled with this course, so don’t wait to download yours now. This course also includes 2.5 hours on-demand video, Full lifetime access, Access on mobile and TV & Certificate of Completion.

What are Cube Aggregates?

  Definition

An aggregate is a materialized, summarized and condensed view of the data in an Info Cube. An aggregate maintain the dataset of an Info Cube redundantly and persistently.

• Summarized and Condensed view refers to the condensing of the fact table of an Info cube to an aggregate table.
• An aggregate table no longer contains certain characteristics of the Info cube and has been condensed across attributes.

When We Create Aggregate on Cube?

Basic purpose of using aggregates is to make data extraction faster.

When we access the data frequently for reporting and we have huge amount of data it takes more time retrieve. If a query is frequently used for reporting and we want performance enhancement then we use aggregates on data source (at Info Cube).

• Aggregation makes data condensed and summarized so you can access the data of an Info Cube quickly when reporting.
• New data is loaded at regular interval (a defined time) using logical data packages (requests) in an aggregate. After this transaction, the new data is available for rolling up in reporting.
• Aggregates are used when we often use navigational attributes in queries or we want aggregation up to specific hierarchy levels for characteristic hierarchies. Both time-dependent attributes and time-dependent hierarchies can be used in aggregates.
• Note:

1. To find our queries frequently used and taking more time we can check RSDDSTAT_OLAP table (TCODE SE11).
2. You can use Table RSDCUBE to determine the Info Cube assigned to the aggregate using aggregate id (6digit).

Prerequisites

• The Info Cube for which we are creating aggregate must be in active state and there should not be any aggregate with same set of attributes for that Info Cube. Every aggregate must be unique.
• If you have created aggregates for an Info Cube and entered data for them, the OLAP processor automatically accesses these aggregates. When navigating, the different results are consistent. The aggregate is transparent for the end user.
• If you want to use system propose aggregates, and then you must create at least one query for the selected Info Cube. The necessary aggregates can be proposed when you start the queries and navigate in them.