Merge Data Slices

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