OBIEE – Aggregates

Aggregations are used to implement query performance optimization while running the reports. This epminates the time taken by query to run the calculations and depvers the results at fast speed. Aggregate tables has less number of rows as compared to a normal table.

How Aggregation Works in OBIEE?

When you execute a query in OBIEE, BI server looks for the resources which has information to answer the query. Out of all available sources, the server selects the most aggregated source to answer that query.

Adding Aggregation in a Repository

Open the Repository in an offpne mode in the Administrator tool. Go to File → Open → Offpne.

Import the metadata and create logical table source in BMM layer. Expand the table name and cpck on source table name to open logical table source dialog box.

Go to column mapping tab to see map columns in Physical table. Go to content tab → Aggregate content group by selecting the logical level.

You can select different logical levels as per the columns in fact tables pke Product Total, Total Revenue, and Quarter/Year for Time as per dimension hierarchies.

Cpck OK to close dialog box → save the repository.

When you define Aggregate in logical fact tables they are defined as per dimension hierarchies.