Get MDX Report Details
get
/applications/{application}/databases/{database}/queries/{query}
Get the details for the specified MDX report.
An MDX report is saved in the cube context.
See also:
Request
Path Parameters
-
application(required):
Application name.
-
database(required):
Database name.
-
query(required):
MDX report name.
Response
200 Response
OK
MDX report details returned successfully.
400 Response
Bad Request
Failed to get MDX report details.
Examples
The following example shows how to get details of an MDX report saved 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 GET https://myserver.example.com:9001/essbase/rest/v1/applications/Sample/databases/Basic/queries/closingperiod -H "Accept:application/json" -u %User%:%Password%
Example of Response Body
The following example shows the contents of the response body in JSON format:
{
"name" : "closingperiod",
"type" : "MDX",
"query" : {
"spec" : "WITH\nMEMBER [Measures].[Starting Inventory] AS\n'\nIIF (\n IsLeaf (Year.CurrentMember),\n [Measures].[Opening Inventory],\n ([Measures].[Opening Inventory],\n OpeningPeriod (\n [Year].Levels(0),\n [Year].CurrentMember\n )\n )\n)'\n\nMEMBER [Measures].[Closing Inventory] AS\n'\nIIF (\n Isleaf(Year.CurrentMember),\n [Measures].[Ending Inventory], \n ([Measures].[Closing Inventory],\n ClosingPeriod (\n [Year].Levels(0),\n [Year].CurrentMember\n )\n)\n)'\nSELECT\nCrossJoin (\n { [100-10] },\n { [Measures].[Starting Inventory], [Measures].[Closing Inventory] }\n)\nON COLUMNS,\nHierarchize ( [Year].Members , POST)\nON ROWS\nFROM Sample.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"
} ]
}