Aggregations are used to implement question performance optimization even as walking the reports. This eliminates the time taken by query to run the calculations and gives you the consequences at speedy velocity. Aggregate tables has less wide variety of rows compared to a everyday table.
How Aggregation Works in OBIEE?
When you execute a query in OBIEE, BI server looks for the resources which has facts to reply the query. Out of all available assets, the server selects the maximum aggregated supply to reply that query.
Adding Aggregation in a Repository
Open the Repository in an offline mode in the Administrator device. Go to File → Open → Offline.
Import the metadata and create logical desk supply in BMM layer. Expand the table name and click on on supply table call to open logical desk source dialog container.
Go to column mapping tab to see map columns in Physical desk. Go to content material tab → Aggregate content group by means of choosing the logical level.
You can pick unique logical degrees as per the columns in truth tables like Product Total, Total Revenue, and Quarter/Year for Time as in step with size hierarchies.
Click OK to close conversation box → save the repository.
When you outline Aggregate in logical reality tables they are described as in step with measurement hierarchies.