Enabling Query Tracking and Creating Aggregate Views Using Calculation Manager
Enabling Query Tracking and Creating Aggregate Views Using Calculation Manager
To use Oracle Hyperion Calculation Manager to enable query tracking and to create aggregate views:
Sign in to Oracle Enterprise Performance Management Cloud.
Click Navigator and then Rules under Create and Manage.
Calculation Manager is displayed.
In Calculation Manager, Click Actions and then Database Properties.
From Enterprise View, expand the database node.
Select an option:
To enable the collection of data retrieval patterns, right-click the cube and select Set Query Tracking.
To create aggregate views, right-click the cube and select Execute Aggregation. If you are creating aggregate views using query tracking data, select options:
Select Include rollup option? to include secondary hierarchies (with default level usage) in the view selection process.
Select Include growth size option? and enter the ratio for maximum cube growth to aggregate the views the server selects, until the maximum growth reaches the ratio that you specify.
Note:
If you are performing a default aggregation, do not select the preceding options.