Merge Slices for Profitability and Cost Management

Merges all incremental data slices into the main database slices.

Optionally, removes the Oracle Essbase cells with zero values to make the cube compact.

Required Roles

Service Administrator, Power User

REST Resource

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

Request

Supported Media Types: application/json

The following table summarizes the client request.

Table 24-27 Parameters

Name	Description	Type	Required	Default
api_version	Version of the API you are developing with	Path	Yes	None
application	Name of the Profitability and Cost Management 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 Body

Supported Media Types: application/json

Table 24-28 Parameters

Name	Description
details	In case of errors, details are published with the error string.
status	See Migration Status Codes
links	Detailed information about the link
href	Links to API call
action	The HTTP call type
rel	Can be self and/or Job Status. If set to Job Status, you can use the href to get the status of the import operation.
data	Parameters as key value pairs passed in the request

Example of Response Body

{
   "type":"Profitability",
   "status":-1,
   "statusMessage":"In Progress",
   "details":"BksML30_MERGE_CUBE_D20220511T115052_771",
   "links":[
      {
"href":"http:// <SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com/epm/rest/v1/applications/jobs/ChecktaskStatusJob/BksML30_MERGE_CUBE_D20220511T115052_771",
         "action":"GET",
         "rel":"Job Status"
      }
   ]
}