Update Dimensions As a Job

Upload a new dimension flat file for an application created using a flat file.

Similar to Update File-Based Application, you can use the new resource to update dimension flat files for an application. However, Update Dimensions As a Job runs asynchronously; it immediately returns the job ID and the job status (Running or Failed). Update File-Based Application runs synchronously and waits until the job finishes to indicate whether the job succeeded or failed.

REST Resource



Supported Media Types: application/json


The following table summarizes the client request.

Table 13-32 Parameters

Name Description Type Required Default
api_version Version of the API you are developing with Path Yes None
application Name of the application to update Path Yes None
dataFileName Dimension Metadata flat file name that has already been uploaded to the Inbox folder; multiple file names can be passed separated by comma or other separator character listed in the stringDelimiter parameter Payload Yes None
stringDelimiter Separator character to use if different from commas Payload No Comma (,)

Example URL and Payload


Response Body

Supported Media Types: application/json

Table 13-33 Parameters

Name Description
details Task ID, such as BksML12_BksML12_ UpdateDimension_D20160118T051020_bb8_1
status See Migration Status Codes
statusMessage Message about the status, such as In Progress
type Profitability
data Parameters as key value pairs
links Detailed information about the link
href Links to API call
action The HTTP call type
rel Relationship type
data Parameters as key value pairs passed in the request

Example of Response Body:

The following shows an example of the response body in JSON format.

  "type": "Profitability",
  "links": [
      "href": "https://<SERVICE_NAME>-<TENANT_NAME>.<SERVICE_TYPE>.<dcX>.oraclecloud.com/epm/rest/<api_version>/fileApplications/BksML12/jobs/updateDimension",
      "action": "POST",
      "rel": "self",
      "data": {
    }, {
        "action": "GET",
        "rel": "Job status"
    "status": -1,
    "details": "BksML12_BksML12_UpdateDimension _D20160118T051020_bb8_1",
    "statusMessage": "In_Progress"