REST API for Oracle Essbase

Save MDX Report

post

/essbase/rest/v1/applications/{application}/databases/{database}/queries

Saves an MDX report for the specified cube.

Request

Supported Media Types

application/json
application/xml

Path Parameters

application(required): string

Application name.
database(required): string

Database name.

Details of query to be saved.

Root Schema : NamedQuery

Type: object

Show Source

name: string
query: object Query
type: string

Allowed Values: [ "MDX", "DATA_SOURCE" ]

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string"
        },
        "type":{
            "type":"string",
            "enum":[
                "MDX",
                "DATA_SOURCE"
            ]
        },
        "query":{
            "$ref":"#/definitions/Query"
        }
    }
}

Nested Schema : Query

Type: object

Show Source

description: string
preferences: object NamedQueriesPreferences
spec: string

{
    "type":"object",
    "properties":{
        "description":{
            "type":"string"
        },
        "spec":{
            "type":"string"
        },
        "preferences":{
            "$ref":"#/definitions/NamedQueriesPreferences"
        }
    }
}

Nested Schema : NamedQueriesPreferences

Type: object

Show Source

cellAttributes: boolean
dataless: boolean

Set to true to omit data values from the output set. Default is false.
formatString: boolean

Set to true to return the formatted values for cells of type text or date, or cells associated with a format string. Default is true.
formatValues: boolean
hideRestrictedData: boolean
meaninglessCells: boolean
memberIdentifierType: string

Allowed Values: [ "NAME", "ALIAS", "UNIQUE_NAME" ]

Specify whether metadata in the output should refer to member names, member aliases, or unique member names (in case of duplicate member enabled outlines).
textList: boolean
urlDrillThrough: boolean

{
    "type":"object",
    "properties":{
        "dataless":{
            "type":"boolean",
            "description":"<p>Set to <b>true</b> to omit data values from the output set. Default is <b>false</b>.</p>"
        },
        "hideRestrictedData":{
            "type":"boolean"
        },
        "cellAttributes":{
            "type":"boolean"
        },
        "formatString":{
            "type":"boolean",
            "description":"<p>Set to <b>true</b> to return the formatted values for cells of type text or date, or cells associated with a format string. Default is <b>true</b>.</p>"
        },
        "formatValues":{
            "type":"boolean"
        },
        "meaninglessCells":{
            "type":"boolean"
        },
        "textList":{
            "type":"boolean"
        },
        "urlDrillThrough":{
            "type":"boolean"
        },
        "memberIdentifierType":{
            "type":"string",
            "description":"<p>Specify whether metadata in the output should refer to member names, member aliases, or unique member names (in case of duplicate member enabled outlines).</p>",
            "enum":[
                "NAME",
                "ALIAS",
                "UNIQUE_NAME"
            ]
        }
    }
}

Response

Supported Media Types

application/json
application/xml

200 Response

MDX report saved successfully.

Root Schema : NamedQuery

Type: object

Show Source

name: string
query: object Query
type: string

Allowed Values: [ "MDX", "DATA_SOURCE" ]

{
    "type":"object",
    "properties":{
        "name":{
            "type":"string"
        },
        "type":{
            "type":"string",
            "enum":[
                "MDX",
                "DATA_SOURCE"
            ]
        },
        "query":{
            "$ref":"#/definitions/Query"
        }
    }
}

Nested Schema : Query

Type: object

Show Source

description: string
preferences: object NamedQueriesPreferences
spec: string

{
    "type":"object",
    "properties":{
        "description":{
            "type":"string"
        },
        "spec":{
            "type":"string"
        },
        "preferences":{
            "$ref":"#/definitions/NamedQueriesPreferences"
        }
    }
}

Nested Schema : NamedQueriesPreferences

Type: object

Show Source

cellAttributes: boolean
dataless: boolean

Set to true to omit data values from the output set. Default is false.
formatString: boolean

Set to true to return the formatted values for cells of type text or date, or cells associated with a format string. Default is true.
formatValues: boolean
hideRestrictedData: boolean
meaninglessCells: boolean
memberIdentifierType: string

Allowed Values: [ "NAME", "ALIAS", "UNIQUE_NAME" ]

Specify whether metadata in the output should refer to member names, member aliases, or unique member names (in case of duplicate member enabled outlines).
textList: boolean
urlDrillThrough: boolean

{
    "type":"object",
    "properties":{
        "dataless":{
            "type":"boolean",
            "description":"<p>Set to <b>true</b> to omit data values from the output set. Default is <b>false</b>.</p>"
        },
        "hideRestrictedData":{
            "type":"boolean"
        },
        "cellAttributes":{
            "type":"boolean"
        },
        "formatString":{
            "type":"boolean",
            "description":"<p>Set to <b>true</b> to return the formatted values for cells of type text or date, or cells associated with a format string. Default is <b>true</b>.</p>"
        },
        "formatValues":{
            "type":"boolean"
        },
        "meaninglessCells":{
            "type":"boolean"
        },
        "textList":{
            "type":"boolean"
        },
        "urlDrillThrough":{
            "type":"boolean"
        },
        "memberIdentifierType":{
            "type":"string",
            "description":"<p>Specify whether metadata in the output should refer to member names, member aliases, or unique member names (in case of duplicate member enabled outlines).</p>",
            "enum":[
                "NAME",
                "ALIAS",
                "UNIQUE_NAME"
            ]
        }
    }
}

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"
  } ]
}