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"
    }
}