Optimizing Aggregation for the PCM_REP Reporting Cube

The Optimize Aggregation job is useful for optimizing aggregation in the Enterprise Profitability and Cost Management reporting cube (PCM_REP). The job generates optimized views based on collected query tracking information in a cube. This job has two actions:

To optimize aggregation for the Enterprise Profitability and Cost Management reporting cube (PCM_REP):

1. From the Home page, select Application, and then Jobs.
2. On the Jobs page, select Actions, and then Schedule.
3. In the General step of the Schedule Job page, select Optimize Aggregation, enter a name for the job, enter information about when and how often you want to run the job, and then click Next.

4. In Job Details, select a cube, and select whether to enable query tracking or execute the aggregation process.

   • Enable Query Tracking: Records a meaningful set of queries, and then uses the recorded query data to select the most appropriate set of aggregate views to materialize for the cube. You must enable query tracking and allow it sufficient time to collect data before executing the aggregation process based on query data.

     Once enabled, query tracking continues until query tracking is disabled, the cube is reloaded or refreshed, the outline is compacted, the application is shut down, or additional aggregate views are materialized for the cube. Query tracking does not resume automatically after these actions occur.

     The following actions clear the stored query tracking information from the aggregate storage cube, but they do not disable query tracking:

     • Merging incremental data slices

     • Clearing data

     • Clearing existing aggregations

     • Clearing partial data

     • Loading data into the aggregate storage cube

   • Execute Aggregation Process: Calculates aggregations for aggregate storage cubes that contain data and to which you are granted Calculation permission.

     To perform an aggregation, you use system recommended views. The selection of views and aggregation processes are combined into one, non-configurable operation performed by the server. You can optionally specify the maximum disk space for the resulting files, base the view selection on user querying patterns, and include rollup hierarchies in the view selection.

     Select one or more of the following options:

     • Based on query data? Aggregate the views the server selects, based on collected user querying patterns. This option is only available if query tracking is turned on.

     • Include rollup option? Include secondary hierarchies (with default level usage) in the view selection process.

     • Include growth size option? Aggregate the views the server selects, until the maximum growth of the aggregated cube exceeds limits you specify. Enter the size (in ratio) beyond which the server should stop the aggregation.

5. Review the details for the job, and then click Finish to run the Optimize Agregation job.

Note:

See Scheduling Jobs for complete information on scheduling jobs.