Tools for Creating DeepSee Web Clients
POST /Data/MDXExecute
[Back] [Next]
   
Server:docs2
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

Executes an MDX query and obtains the results.
URL Parameters
None. Note that a request body is required; see the next heading.
Request Body Details
This service uses the following properties of the request body:
MDX Required. MDX SELECT QUERY.
FILTERS Optional. Any additional filters to add to the query. If specified, this property must be an array of strings, each of which specifies a filter value.
WAIT Optional. Specify 0 (the default) or 1. If this property is 0, the server assumes the client wishes to wait for complete results before sending a response. If this property is 1, the server sends partial results.
TIMEOUT Optional. Timeout for waiting for query results, in seconds. The default timeout for this wait is 2 seconds less than the session’s timeout setting.
Example Request
Example Response
{ 
   "Info":{
      "Error":"",
      "MDXText":"SELECT [AGED].[AGE GROUP].MEMBERS ON 0 FROM [PATIENTS]",
      "QueryKey":"en2772997983",
      "CubeKey":"PATIENTS",
      "QueryID":"PATIENTS||en2772997983",
      "Cube":"PATIENTS",
      "ResultsComplete":1,
      "Pivot":"",
      "QueryType":"SELECT",
      "ListingSource":"",
      "ColCount":3,
      "RowCount":0,
      "TimeStamp":"2016-08-14 16:05:16"}
      ,"AxesInfo":[
         {"%ID":"SlicerInfo","Text":""},
         {"%ID":"AxisInfo_1","Text":"[AGED].[AGE GROUP].MEMBERS"},
         {"%ID":"AxisInfo_2","Text":"[%SEARCH]"}
      ],
 "Result":
   {"Axes":[
       {"%ID":"Axis_1","Tuples":
         [{"%ID":"Tuple_1",
           "Members":[{"%ID":"Member_1",
                       "Name":"0 to 29"}],
                       "MemberInfo":
                          [{"%ID":"MemberInfo_1",
                            "nodeNo":3,"text":"0 to 29",
                            "dimName":"AgeD",
                            "hierName":"H1",
                            "levelName":"Age Group",
                            "memberKey":"0 to 29",
                            "dimNo":2,
                            "hierNo":1,
                            "levelNo":2,
                            "aggregate":"",
                            "orSpec":""}]},
       {"%ID":"Tuple_2",...},
       {"%ID":"Tuple_3",...}],
    "TupleInfo":[
          {"%ID":"TupleInfo_1","childSpec":"[AgeD].[H1].[Age Group].&[0 to 29].children"},
          {"%ID":"TupleInfo_2","childSpec":"[AgeD].[H1].[Age Group].&[30 to 59].children"}
           ...],
   "CellData":[
         {"%ID":"Cell_1","ValueLogical":418,"Format":"","ValueFormatted":"418"},
         {"%ID":"Cell_2","ValueLogical":421,"Format":"","ValueFormatted":"421"},
         ...]}
}
If the response is incomplete, it includes cell data objects like the following:
{"%ID":"Cell_9","ValueLogical":"@Computing 0.00%","Format":"","ValueFormatted":"@Computing 0.00%"}
Note that POST /Data/PivotExecute returns the same response body.
The Info.QueryID property contains the query ID, which you need as input for the POST /Data/MDXCancelQuery and POST /Data/MDXUpdateResults services.
For information that applies to all response objects, see the discussion at the start of this reference.