Collecting User Data Retrieval Patterns and Creating Aggregate Views Using Jobs

To enable query tracking and to create aggregate views using jobs:

1. Sign in to Oracle Enterprise Performance Management Cloud.
2. Click Application, then Jobs, and then click Schedule Jobs.
3. Select Optimize Aggregation as the job type.
4. In Name, enter a name for the job.
5. Select when to run the job. You can run a job right away or schedule it to run at a later time.
6. Click Next.
7. In Job Details, select the ASO cube for optimizing aggregation.
8. Select what you want to do:
   • Select Enable query tracking to start capturing user data retrieval patterns (queries).
   • Select Execute Aggregation Process to create aggregate views, and then select options:

     Note:

     Do not select these options to run default aggregation.
     • Select Based on query data? to use recorded query data to select the most appropriate set of aggregate views. Use this option only if query tracking has been turned on.
     • 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.
9. Click Next and then review the selected job settings.
10. Click Finish.