REST API for Oracle Essbase

Save MDX Report

post

/applications/{application}/databases/{database}/queries

Saves an MDX report for the specified cube.

Request

Path Parameters

application(required):

Application name.
database(required):

Database name.

Response

200 Response

MDX report saved successfully.

400 Response

Bad Request

Failed to save MDX report.

Examples

The following example shows how to save an MDX report in the context of an Essbase cube.

This example uses cURL to access the REST API from a Windows shell script. The calling user's ID and password are variables whose values are set in properties.bat.

Script with cURL Command

call properties.bat
curl -X POST https://myserver.example.com:9001/essbase/rest/v1/applications/ASOSamp/databases/Basic/queries -H "Accept:application/json" -H "Content-Type:application/json" --data "@./mdxAggregateT1.json" -u %User%:%Password%

Sample JSON Payload

The cURL example above delivers the following JSON payload in mdxAggregateT1.json.

{
  "name" : "mdxAggregateT1",
  "type" : "MDX",
  "query" : {
    "spec" : "WITH \n SET [T1] AS '{[Time].[1st Half]}'\n SET [GM] AS '{Children ( [Geography].[South] )}'\n MEMBER [Measures].[m1] as 'Aggregate(CrossJoin([T1],{[Geography].CurrentMember}),[Measures].[Price Paid])'\nSELECT \n {[Measures].[m1]} \nON COLUMNS,\n NON EMPTY {CrossJoin([T1] ,[GM])}\nON ROWS\nFROM ASOSamp.Basic"
  }
}

Example of Response Body

The following example shows the contents of the response body in JSON format:

{
  "name" : "mdxAggregateT1",
  "type" : "MDX",
  "query" : {
    "spec" : "WITH \n SET [T1] AS '{[Time].[1st Half]}'\n SET [GM] AS '{Children ( [Geography].[South] )}'\n MEMBER [Measures].[m1] as 'Aggregate(CrossJoin([T1],{[Geography].CurrentMember}),[Measures].[Price Paid])'\nSELECT \n {[Measures].[m1]} \nON COLUMNS,\n NON EMPTY {CrossJoin([T1] ,[GM])}\nON ROWS\nFROM ASOSamp.Basic"
  },
  "links" : [ {
    "rel" : "self",
    "method" : "GET"
  }, {
    "rel" : "delete",
    "method" : "DELETE"
  }, {
    "rel" : "update",
    "method" : "PUT"
  }, {
    "rel" : "Get data In JSON",
    "method" : "GET"
  }, {
    "rel" : "Get data in HTML",
    "href" : "?format=HTML",
    "method" : "GET"
  }, {
    "rel" : "Get data in Excel",
    "href" : "?format=XLSX",
    "method" : "GET"
  }, {
    "rel" : "Get data in CSV",
    "href" : "?format=CSV",
    "method" : "GET"
  } ]
}