Selecting Views Based on Usage

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.

  To track data query patterns, use a tool:

Tool

Topic

Location

Administration Services

Tracking Query Data for Aggregation View Selection

Oracle Essbase Administration Services Online Help

MaxL

alter database

Oracle Essbase Technical Reference

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.