Merge Slices for Oracle Profitability and Cost Management Cloud

Merges all incremental data slices into the main database slice and optionally removes the Essbase cells with zero values to make the cube compact.

REST Resource

POST/epm/rest/{api_version}/applications/{application}/jobs/mergeSlices

Request

Supported Media Types: application/json

Parameters

The following table summarizes the client request.

Table 13-15 Parameters

Name Description Type Required Default
api_version Version of the API you are developing with Path Yes None
application Name of the Oracle Profitability and Cost Management Cloud application Path Yes None
removeZeroCells If "true", removes cells with zero values Path No "false"

Request URI Example:

https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com/epm/rest/v1/applicaitions/BksML30/jobs/mergeSlices

Request Payload:

  {
   "removeZeroCells":"true"
   )

Response

Parameters

The following table summarizes the response parameters.

Supported Media Types: application/json

Example of Response Body

{
    "type": "Profitability",
    "status": -1,
    "statusMessage": "In Progress",
    "details": "BksML30_MergeSlices_D20161003T033953_b06",
    "links": [{
        "action": "POST"
        "href": "https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com/epm/rest/v1/applications/BksML30/jobs/mergeSlices,
        "rel": "self"
"data": {
        "removeZeroCe4lls": "true"
        }
    }, {
        "action": "GET",
        "href": "https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com/epm/rest/v1/applications/BksML30/jobs/checkTaskStatusJob/"BksML30_MergeSlices_D20161003T033953_b06",
 "GET",
        "rel": "Job Status",

         }]
}