Executing the Aggregation Process

Executing the aggregation process improves retrieval performance.

ASO cubes do not use calculation scripts to aggregate the data; instead, ASO attempts to dynamically calculate upper level members. This can result in faster batch processing time, but might result in longer retrieval times. You can improve this situation by turning on Query Tracking to capture queries against the ASO cube for operations such as working with forms and running ad-hoc reports. These queries are used in aggregate process, which tells Oracle Essbase to use the query patterns picked up by Query Tracking to build the Aggregation views. Once the aggregate views are created, you should see an improvement in retrieval performance.

Before executing the aggregation process, do the following:

• Merge Incremental Data Slices and Remove Zero Value Cells
• Enable Query Tracking
• Perform Actions to Create Queries
• Execute Aggregation Using Query Tracking