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.

Request

Supported Media Types: application/json

Parameters

The following table summarizes the client request specific to this job. For parameters that are generic to all jobs, see Execute a Job.

Table 5-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

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