Enabling Query Tracking in ASO Database

The following steps provide the retrieval statistics for alternate views from ASO.

1. Load data.
2. Aggregate the data using (right mouse click on the database, select Aggregation design Wizard). 
3. 1st time, select radio button "Use recommended views to materialize aggregation".
4. Next, right mouse click on the database and select "Query Tracking" -> "Enable Query Tracking".
5. Next, drill down to the intersection you want to aggregate from the Excel add-in. Be sure to drill from parent to children so that you have from 5 to 9 retrievals.
6. In EAS right mouse click on the database to select Aggregation Design Wizard again.
7. This time select Design, materialize, and Save aggregation.
8. Next select "Add to existing aggregate view selection".
9. Next select "Select all recommended aggregate views".
10. Next select "Use query tracking data during view selection".
11. Start 
12. Next select Materialize aggregation. 
13. Finish

This will track usage patterns and allow for aggregations which will hopefully be more efficient to the client's query patterns.  You have to make sure you have data in the database and you should do a few retrievals (10 to be exact) to setup a pattern to ensure that query tracking will work.

For more information please refer to “Selecting Views Based on Usage” in the Hyperion Essbase - Database Administrator's Guide  and  "Tracking Query Data for Aggregation View Selection" in the Essbase Essbase Administration Services Online Help at the following link:
http://www.oracle.com/technetwork/middleware/performance-management/documentation/index.html