1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Administering Essbase Servers, Applications, and Databases for Planning Applications
  3. Executing the Aggregation Process
  4. Enable Query Tracking

Enable Query Tracking

You can enable query tracking for ASO databases to record a meaningful set of queries, and then use the recorded query data to select the most appropriate set of aggregate views to materialize for that database.

The cube refresh operation done in Planning performs an outline restructure operation. As part of the restructure operation, Oracle Essbase removes the tracked queries. A merge operation also removes the tracked queries.

To enable query tracking:

  1. In Enterprise View, expand Planning, then expand the ASO application, then right-click the ASO cube, and then select Set Query Tracking.
  2. Click OK to confirm the query tracking action.
  3. Click OK in the Information dialog box that informs you that query tracking on the database was enabled successfully.
Once you enable Query Tracking, it can be disabled by repeating the steps above. If you disable query tracking, the Information dialog box informs you that Query Tracking in enabled, and asks you if you want to disable query tracking, stop the application, or execute the Aggregation process.