Creating Required Aggregate Views
Aggregate or materialized views are higher level dimension intersections that calculate and store a part of the data to disk based on hierarchies. They enhance retrieval performance by storing calculated data. You must re-create aggregate views when new data slices are created.
Optimizing aggregation can significantly improve the performance of ASO cubes. ASO cubes support default aggregation and query tracking aggregation. Query tracking aggregation requires that you enable query tracking and allow a sufficient time to allow the system to capture user data retrieval patterns which can then be used to create aggregate views. You can enable query tracking using a job or using Oracle Hyperion Calculation Manager.
Note:
Existing query tracking data, if any, is removed when you merge data slices.See the following topics: