Merge Data Slices
This REST API merges incremental data slices of an ASO cube. Fewer slices improve a cube’s performance.
You can merge all incremental data slices into the main database slice or merge all incremental data slices into a single data slice without changing the main database slice. You can optionally remove cells that have a value of zero. For more information, see Scheduling Jobs.
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
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-22 Parameters
Name | Description | Required | Default |
---|---|---|---|
jobType |
Merge Data Slices | Yes | None |
jobName |
The job name to be used for this job execution. Example: MergeDataSlice | No | Merge Data Slices |
cubeName |
Name of the ASO cube | Yes | None |
keepZeroCells |
Possible values are true or false | Yes | None |
mergeSliceType |
Possible values are allIncrementalSlicesInMain (Merge all into the main slice) Or allIncrementalSlicesInOneIncremental (Merge all incremental into a single incremental slice) |
Yes | None |
For a sample URL, see Sample URL and Payload in Execute a Job.
Sample Payload
Example: This request will merge all incremental data slices in the main data slice and keep zero value cells.
{
"jobType": "Merge Data Slices",
"jobName": "MergeDataSlice",
"parameters": {
"cubeName": "VisASO",
"mergeSliceType": "allIncrementalSlicesInMain",
"keepZeroCells": "true"
}
}