Optimize Aggregation
Improves the performance of ASO cubes. This job has two actions: Enable query tracking and Execute aggregation process. It performs an aggregation, optionally specifying the maximum disk space for the resulting files, and optionally basing the view selection on user querying patterns. This API is only applicable to aggregate storage databases. For information about scheduling jobs, see Scheduling Jobs.
Before using this API, you must first enable query tracking to capture tracking statistics on the aggregate storage cube. Then, after you enable query tracking, you must allow sufficient time to collect user data-retrieval patterns before you execute the aggregation process based on query data. The execute aggregation process deletes existing aggregated views and generates optimized views based on the collected query tracking data.
Using this REST API requires prerequisites, such as understanding how to use jobs. See Prerequisites. Be sure that you understand how to use jobs as described in Managing Jobs.
Required Roles
Service Administrator
REST Resource
POST /HyperionPlanning/rest/{api_version}/applications/{application}/jobs/{jobId}
Request
Supported Media Types: application/json
Parameters
The following table summarizes the client request parameters specific to this job. For additional parameters that are common to all jobs, see Execute a Job.
Table 8-23 Parameters
Name | Description | Required | Default |
---|---|---|---|
jobType |
Optimize Aggregation | Yes | None |
jobName |
The job name to be used for this job execution | No | Optimize Aggregation |
parameters |
Parameters required for the job | Yes | None |
cubeName |
Name of the ASO cube | Yes | None |
type |
Can take one of these values: enableQueryTracking or executeAggregationProcess | Yes | None |
useQueryData |
Aggregate the views the server selects based on collected user querying patterns. This option is only available if query tracking is turned on. Permissible values: true or false. Default: false. Applicable only if type is executeAggregationProcess. | No | None |
includeAlternateRollups |
Include secondary hierarchies (with default level usage) in the view selection. Permissible values: disable or enable. Default: disable (no secondary hierarchies are considered). Applicable only if type is executeAggregationProcess. | No | None |
growthSizeRatio |
Aggregates the views the server selects until the maximum growth of the aggregated database exceeds the limits you specify. The value can be a real number such as 1.01. Default is that the database will grow without any growth ratio limit. Applicable only if type is executeAggregationProcess . | No | None |
For a sample URL, see Sample URL and Payload in Execute a Job.
Sample Payload
Example 1: This request will enable query tracking on the Vis1ASO cube.
{
"jobType": "Optimize Aggregation",
"jobName": "CubeOptimizeAggr",
"parameters": {
"cubeName": "Vis1ASO",
"type": "enableQueryTracking"
}
}
Example 2: This request will execute the aggregation process on the Vis1ASO cube.
{
"jobType": "Optimize Aggregation",
"jobName": "CubeOptimizeAggr",
"parameters": {
"cubeName": "Vis1ASO",
"type": "executeAggregationProcess"
}
}
Example 3: This request will execute aggregation process on the Vis1ASO cube. Aggregation process will use the query tracking data, will not include alternate roll ups, and use growth size ratio as 1.01.
{
"jobType": "Optimize Aggregation",
"jobName": "CubeOptimizeAggr",
"parameters": {
"cubeName": "Vis1ASO",
"type": "executeAggregationProcess",
"useQueryData": "true",
"includeAlternateRollups": "disable",
"growthSizeRatio": "1.01"
}
}