forked from eduard93/Cache-MDX2JSON
-
Notifications
You must be signed in to change notification settings - Fork 8
MDX output with DeepSeeREST engine
Eduard edited this page Nov 5, 2015
·
1 revision
POST request to http://localhost:57772/mdx2json/MDX?Namespace=Samples
With body: { "MDX": "SELECT NON EMPTY [Product].[P1].[Product Category].Members ON 0,NON EMPTY [Outlet].[H1].[Region].Members ON 1 FROM [HoleFoods]", "Engine":"DeepSeeREST"}
Note that it is availible only on 2015.3+
Output:
{
"Info":{
"Error":"",
"TimeStamp":"2015-11-05 13:37:26",
"ResultsComplete":1,
"MDXText":"SELECT NON EMPTY [PRODUCT].[P1].[PRODUCT CATEGORY].MEMBERS ON 0,NON EMPTY [OUTLET].[H1].[REGION].MEMBERS ON 1 FROM [HOLEFOODS]",
"QueryKey":"ru871132280",
"CubeKey":"HOLEFOODS",
"QueryID":"HOLEFOODS||ru871132280",
"Cube":"HoleFoods",
"Pivot":"",
"QueryType":"SELECT",
"ListingSource":"",
"ColCount":8,
"RowCount":4
},
"AxesInfo":[
{
"%ID":"SlicerInfo",
"Text":""
},
{
"%ID":"AxisInfo_1",
"Text":"NON EMPTY [PRODUCT].[P1].[PRODUCT CATEGORY].MEMBERS"
},
{
"%ID":"AxisInfo_2",
"Text":"NON EMPTY [OUTLET].[H1].[REGION].MEMBERS"
}
],
"Result":{
"Axes":[
{
"%ID":"Axis_1",
"Tuples":[
{
"%ID":"Tuple_1",
"Members":[
{
"%ID":"Member_1",
"Name":"Candy"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":3,
"text":"Candy",
"dimName":"Product",
"hierName":"P1",
"levelName":"Product Category",
"memberKey":"Candy",
"dimNo":4,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_2",
"Members":[
{
"%ID":"Member_1",
"Name":"Cereal"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":4,
"text":"Cereal",
"dimName":"Product",
"hierName":"P1",
"levelName":"Product Category",
"memberKey":"Cereal",
"dimNo":4,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_3",
"Members":[
{
"%ID":"Member_1",
"Name":"Dairy"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":5,
"text":"Dairy",
"dimName":"Product",
"hierName":"P1",
"levelName":"Product Category",
"memberKey":"Dairy",
"dimNo":4,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_4",
"Members":[
{
"%ID":"Member_1",
"Name":"Fruit"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":6,
"text":"Fruit",
"dimName":"Product",
"hierName":"P1",
"levelName":"Product Category",
"memberKey":"Fruit",
"dimNo":4,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_5",
"Members":[
{
"%ID":"Member_1",
"Name":"Pasta"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":7,
"text":"Pasta",
"dimName":"Product",
"hierName":"P1",
"levelName":"Product Category",
"memberKey":"Pasta",
"dimNo":4,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_6",
"Members":[
{
"%ID":"Member_1",
"Name":"Seafood"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":8,
"text":"Seafood",
"dimName":"Product",
"hierName":"P1",
"levelName":"Product Category",
"memberKey":"Seafood",
"dimNo":4,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_7",
"Members":[
{
"%ID":"Member_1",
"Name":"Snack"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":9,
"text":"Snack",
"dimName":"Product",
"hierName":"P1",
"levelName":"Product Category",
"memberKey":"Snack",
"dimNo":4,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_8",
"Members":[
{
"%ID":"Member_1",
"Name":"Vegetable"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":10,
"text":"Vegetable",
"dimName":"Product",
"hierName":"P1",
"levelName":"Product Category",
"memberKey":"Vegetable",
"dimNo":4,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
}
],
"TupleInfo":[
{
"%ID":"TupleInfo_1",
"childSpec":"[Product].[P1].[Product Category].&[Candy].children"
},
{
"%ID":"TupleInfo_2",
"childSpec":"[Product].[P1].[Product Category].&[Cereal].children"
},
{
"%ID":"TupleInfo_3",
"childSpec":"[Product].[P1].[Product Category].&[Dairy].children"
},
{
"%ID":"TupleInfo_4",
"childSpec":"[Product].[P1].[Product Category].&[Fruit].children"
},
{
"%ID":"TupleInfo_5",
"childSpec":"[Product].[P1].[Product Category].&[Pasta].children"
},
{
"%ID":"TupleInfo_6",
"childSpec":"[Product].[P1].[Product Category].&[Seafood].children"
},
{
"%ID":"TupleInfo_7",
"childSpec":"[Product].[P1].[Product Category].&[Snack].children"
},
{
"%ID":"TupleInfo_8",
"childSpec":"[Product].[P1].[Product Category].&[Vegetable].children"
}
]
},
{
"%ID":"Axis_2",
"Tuples":[
{
"%ID":"Tuple_1",
"Members":[
{
"%ID":"Member_1",
"Name":"Asia"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":3,
"text":"Asia",
"dimName":"Outlet",
"hierName":"H1",
"levelName":"Region",
"memberKey":"Asia",
"dimNo":5,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_2",
"Members":[
{
"%ID":"Member_1",
"Name":"Europe"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":4,
"text":"Europe",
"dimName":"Outlet",
"hierName":"H1",
"levelName":"Region",
"memberKey":"Europe",
"dimNo":5,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_3",
"Members":[
{
"%ID":"Member_1",
"Name":"N. America"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":5,
"text":"N. America",
"dimName":"Outlet",
"hierName":"H1",
"levelName":"Region",
"memberKey":"N. America",
"dimNo":5,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
},
{
"%ID":"Tuple_4",
"Members":[
{
"%ID":"Member_1",
"Name":"S. America"
}
],
"MemberInfo":[
{
"%ID":"MemberInfo_1",
"nodeNo":6,
"text":"S. America",
"dimName":"Outlet",
"hierName":"H1",
"levelName":"Region",
"memberKey":"S. America",
"dimNo":5,
"hierNo":1,
"levelNo":2,
"aggregate":"",
"orSpec":""
}
]
}
],
"TupleInfo":[
{
"%ID":"TupleInfo_1",
"childSpec":"[Outlet].[H1].[Region].&[Asia].children"
},
{
"%ID":"TupleInfo_2",
"childSpec":"[Outlet].[H1].[Region].&[Europe].children"
},
{
"%ID":"TupleInfo_3",
"childSpec":"[Outlet].[H1].[Region].&[N. America].children"
},
{
"%ID":"TupleInfo_4",
"childSpec":"[Outlet].[H1].[Region].&[S. America].children"
}
]
}
],
"CellData":[
{
"%ID":"Cell_1",
"ValueLogical":20,
"Format":"",
"ValueFormatted":"20"
},
{
"%ID":"Cell_2",
"ValueLogical":23,
"Format":"",
"ValueFormatted":"23"
},
{
"%ID":"Cell_3",
"ValueLogical":"",
"Format":"",
"ValueFormatted":""
},
{
"%ID":"Cell_4",
"ValueLogical":41,
"Format":"",
"ValueFormatted":"41"
},
{
"%ID":"Cell_5",
"ValueLogical":109,
"Format":"",
"ValueFormatted":"109"
},
{
"%ID":"Cell_6",
"ValueLogical":30,
"Format":"",
"ValueFormatted":"30"
},
{
"%ID":"Cell_7",
"ValueLogical":60,
"Format":"",
"ValueFormatted":"60"
},
{
"%ID":"Cell_8",
"ValueLogical":40,
"Format":"",
"ValueFormatted":"40"
},
{
"%ID":"Cell_9",
"ValueLogical":21,
"Format":"",
"ValueFormatted":"21"
},
{
"%ID":"Cell_10",
"ValueLogical":12,
"Format":"",
"ValueFormatted":"12"
},
{
"%ID":"Cell_11",
"ValueLogical":19,
"Format":"",
"ValueFormatted":"19"
},
{
"%ID":"Cell_12",
"ValueLogical":28,
"Format":"",
"ValueFormatted":"28"
},
{
"%ID":"Cell_13",
"ValueLogical":66,
"Format":"",
"ValueFormatted":"66"
},
{
"%ID":"Cell_14",
"ValueLogical":21,
"Format":"",
"ValueFormatted":"21"
},
{
"%ID":"Cell_15",
"ValueLogical":37,
"Format":"",
"ValueFormatted":"37"
},
{
"%ID":"Cell_16",
"ValueLogical":25,
"Format":"",
"ValueFormatted":"25"
},
{
"%ID":"Cell_17",
"ValueLogical":20,
"Format":"",
"ValueFormatted":"20"
},
{
"%ID":"Cell_18",
"ValueLogical":23,
"Format":"",
"ValueFormatted":"23"
},
{
"%ID":"Cell_19",
"ValueLogical":17,
"Format":"",
"ValueFormatted":"17"
},
{
"%ID":"Cell_20",
"ValueLogical":37,
"Format":"",
"ValueFormatted":"37"
},
{
"%ID":"Cell_21",
"ValueLogical":86,
"Format":"",
"ValueFormatted":"86"
},
{
"%ID":"Cell_22",
"ValueLogical":36,
"Format":"",
"ValueFormatted":"36"
},
{
"%ID":"Cell_23",
"ValueLogical":59,
"Format":"",
"ValueFormatted":"59"
},
{
"%ID":"Cell_24",
"ValueLogical":43,
"Format":"",
"ValueFormatted":"43"
},
{
"%ID":"Cell_25",
"ValueLogical":6,
"Format":"",
"ValueFormatted":"6"
},
{
"%ID":"Cell_26",
"ValueLogical":15,
"Format":"",
"ValueFormatted":"15"
},
{
"%ID":"Cell_27",
"ValueLogical":5,
"Format":"",
"ValueFormatted":"5"
},
{
"%ID":"Cell_28",
"ValueLogical":15,
"Format":"",
"ValueFormatted":"15"
},
{
"%ID":"Cell_29",
"ValueLogical":35,
"Format":"",
"ValueFormatted":"35"
},
{
"%ID":"Cell_30",
"ValueLogical":11,
"Format":"",
"ValueFormatted":"11"
},
{
"%ID":"Cell_31",
"ValueLogical":23,
"Format":"",
"ValueFormatted":"23"
},
{
"%ID":"Cell_32",
"ValueLogical":17,
"Format":"",
"ValueFormatted":"17"
}
]
}
}