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
Note:
Before using the REST resources, you must understand how to access the REST resources and other important concepts. See Implementation Best Practices for EPM Cloud REST APIs. Using this REST API requires prerequisites. See Prerequisites.
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://<BASE-URL>/epm/rest/v1/applicaitions/BksML30/jobs/mergeSlices
Request Payload:
{
"removeZeroCells":"true"
)
Response
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://<BASE-URL>/epm/rest/v1/applications/jobs/ChecktaskStatusJob/BksML30_MERGE_CUBE_D20220511T115052_771",
"action":"GET",
"rel":"Job Status"
}
]
}