| |
GeekInterview.com > Interview Questions > Data Warehousing > Business Objects
| Print | |
Question: Aggregation
Answer: can anyone tell me about
1)aggregation at microcube level
2)aggregation at database level |
| July 07, 2008 20:03:46 |
#1 |
| fir_dan |
Member Since: July 2008 Total Comments: 2 |
RE: Aggregation
|
Aggregation at Microcube level means the data is pulled from the database and aggregated on the BO server. For example if you want total sales of a product category all the records of the that paticular product category are brought into the cube and BO then aggregates it to sum. Even thought report displays only the aggregated value if you look at the data provider all the records of that product category will be available.
Aggregation at the database level means the aggregation is performed at the database which means only the aggregated value will be send from the database. The details of the records which contributed to the aggregation will not be available for BO. In the above example the total sales of each product category ie if there are five product categories then only five records will be made available to BO.
If there is aggregate function like sum at the defintion of the object at the universe level then its a database aggregation and if there is a aggregate function at the report level its a microcube aggregation.
If you view the sql of the report there will be considerable difference ie for database aggregation the sql will contain aggregate function with a group by clause and the microcube aggregation will not have it. |
| |
Back To Question | |
