1. REST API Reference
  2. APIs for Management Ledger
  3. ML Essbase Data Load

ML Essbase Data Load

Use this resource to load data to Oracle Essbase for a Management Ledger application without using the EAS Console. Note that it can upload a local data file to Profitability and Cost Management to be used for the data load to Essbase. To do this, the client code needs to attach the local data file content to the payload of this resource.

Table 3-15 ML Essbase Data Load

Name Description
Action Type POST
Request URI http://myServer.mydomain.com:19000/profitability/rest/v1/applications/{applicationName}/ jobs/essbaseDataLoadJob
Request Payload 
{
"clearAllDataFlag":"true",
"dataLoadValue":"OVERWRITE_EXISTING_VALUES",
"rulesFileName":"rule.txt",
"dataFileName":"input.txt"
}
Response 
{
  "type": "Profitability",
  "links": [
    {
      "href": " http://myServer.mydomain.com:19000/profitability/rest/v1/applications/BksML12/ jobs/ essbaseDataLoadJob ",
      "action": "POST",
      "rel": "self",
      "data": {
      "clearAllDataFlag":"true",
       "dataLoadValue":"OVERWRITE_EXISTING_VALUES",
       "rulesFileName":"rule.txt",
       "dataFileName":"input.txt"
        }
    }, {
        "href": "http://myServer.mydomain.com:19000/profitability/rest/v1/applications/jobs/ChecktaskStatusJob/BksML12_BksML12_LoadData_D20160118T051020_ba8_1",
        "action": "GET",
        "rel": "Job status"
        }
    ],
    "status": -1,
    "details": "BksML12_BksML12_LoadData_D20160118T051020_ba8_1",
    "statusMessage": "In_Progress"
}
Process Type Asynchronous

Table 3-16 Request Parameters

Parameter Description Example
applicationName Application Name BksML12
clearAllDataFlag Clear existing data before load: true/false  
dataLoadValue

OVERWRITE_EXISTING_VALUES

ADD_EXISTING_VALUES

  
rulesFileName Name of the rule file already present in import_export location of the server machine. (Optional parameter) Rule1.txt
dataFileName

Name of the data file already present in the import_export location of the server.

(Mandatory parameter)

 Inpdat1.txt

Response Values: None