how do u deceided to go create Aggregates for cube. what purpose u want to create aggregates?
When we access the data frequently for reporting and when the data is in huge quantity, we face delayed data retrival problem. To overcome this problem we can go for aggregates. This improves the query performance.