forked from eduard93/Cache-MDX2JSON
-
Notifications
You must be signed in to change notification settings - Fork 9
MDX output
Eduard edited this page Oct 8, 2015
·
1 revision
{
"Cols":[ {
"tuples":[ {
"caption":"Candy",
"dimension":"Product Category",
"format":"",
"info":"",
"path":"[Product].[P1].[Product Category].&[Candy]",
"total":"",
"type":"mbr",
"valueID":8
}, {
"caption":"Cereal",
"dimension":"Product Category",
"format":"",
"info":"",
"path":"[Product].[P1].[Product Category].&[Cereal]",
"total":"",
"type":"mbr",
"valueID":6
}, {
"caption":"Dairy",
"dimension":"Product Category",
"format":"",
"info":"",
"path":"[Product].[P1].[Product Category].&[Dairy]",
"total":"",
"type":"mbr",
"valueID":1
}, {
"caption":"Fruit",
"dimension":"Product Category",
"format":"",
"info":"",
"path":"[Product].[P1].[Product Category].&[Fruit]",
"total":"",
"type":"mbr",
"valueID":3
}, {
"caption":"Pasta",
"dimension":"Product Category",
"format":"",
"info":"",
"path":"[Product].[P1].[Product Category].&[Pasta]",
"total":"",
"type":"mbr",
"valueID":4
}, {
"caption":"Seafood",
"dimension":"Product Category",
"format":"",
"info":"",
"path":"[Product].[P1].[Product Category].&[Seafood]",
"total":"",
"type":"mbr",
"valueID":5
}, {
"caption":"Snack",
"dimension":"Product Category",
"format":"",
"info":"",
"path":"[Product].[P1].[Product Category].&[Snack]",
"total":"",
"type":"mbr",
"valueID":2
}, {
"caption":"Vegetable",
"dimension":"Product Category",
"format":"",
"info":"",
"path":"[Product].[P1].[Product Category].&[Vegetable]",
"total":"",
"type":"mbr",
"valueID":7
}
]
}, {
"tuples":[ {
"caption":"Asia",
"dimension":"Region",
"format":"",
"info":"",
"path":"[Outlet].[H1].[Region].&[Asia]",
"total":"",
"type":"mbr",
"valueID":4
}, {
"caption":"Europe",
"dimension":"Region",
"format":"",
"info":"",
"path":"[Outlet].[H1].[Region].&[Europe]",
"total":"",
"type":"mbr",
"valueID":1
}, {
"caption":"N. America",
"dimension":"Region",
"format":"",
"info":"",
"path":"[Outlet].[H1].[Region].&[N. America]",
"total":"",
"type":"mbr",
"valueID":3
}, {
"caption":"S. America",
"dimension":"Region",
"format":"",
"info":"",
"path":"[Outlet].[H1].[Region].&[S. America]",
"total":"",
"type":"mbr",
"valueID":2
}
]
}
],
"Data":[15,10,"",31,90,17,98,44,17,9,17,34,50,15,70,51,12,18,20,27,55,21,109,44,3,1,15,15,10,9,50,23
],
"Info": {
"colCount":4,
"colKey":"en3477013390",
"cubeClass":"HoleFoods.Cube",
"cubeName":"HoleFoods",
"decimalSeparator":".",
"numericGroupSeparator":",",
"numericGroupSize":3,
"queryKey":"en871132280",
"rowCount":8,
"rowKey":"en2993339286"
}
}