Essbase enables you to capture retrieval statistics against a database. You can then use these statistics to build aggregations tailored to retrieval patterns in your company. Also, Essbase includes alternate hierarchies in its analysis of the database when usage information is used in the aggregate view selection process.
Database usage for periodic reporting may be different than for ongoing user retrievals. To optimize different retrieval situations, consider tracking situational usage patterns and creating aggregation scripts for each situation.
Before you begin the aggregation selection process, ensure that query tracking is on and that it has been on long enough to capture representative usage.
Query tracking holds query usage information in memory. Performing any of the following operations clears query usage information.
Query tracking remains on until you turn it off, stop the application, or change the outline.