Get information about the adaptive grid and the values of a generic object by using the GetHyperCubeBinnedData method.
This method supports data binning.
Information noteThe generic object should contain two measures and one dimension.
Examples
Example 1:
Depending on the refinement level, cells (group of points) are rendered instead of points.
The generic object is a hypercube that contains two measures Sales and Loyalty and one dimension Customer.
In the case of the scatter plot visualization shown below, the level of details is not high, so cells are rendered.
The corresponding request from the client is:
{
"method": "GetHyperCubeBinnedData",
"handle": 6,
"params": [
"/qHyperCubeDef",
[
{
"qTop": 0,
"qLeft": 0,
"qWidth": 3,
"qHeight": 17017
}
],
{
"qWidth": 0,
"qHeight": 0
},
[
{
"qLeft": -2644351.631545414,
"qTop": 911.3638368475922,
"qWidth": 45786832.74927128,
"qHeight": 915.7366549854255
}
],
1000,
5,
0
],
"id": 66,
"jsonrpc": "2.0"
}
In the first array:
- qWidth is 3 because the generic object contains two measures and one dimension.
- qHeight is 17017 to render 17017 dimension values.
In the second array:
- qLeft gives the lowest value of the Sales measure.
- qTop gives the highest value of the Loyalty measure.
- qWidth gives the highest value of the Sales measure.
- (qTop- qHeight ) gives the lowest value of the Loyalty measure.
The maximum number of cells in the grid is 1000.
The level of details that is provided is 5.
The engine returns:
{
"jsonrpc": "2.0",
"id": 66,
"result": {
"qDataPages": [
{
"qMatrix": [
[
{
"qNum": 8702,
"qElemNumber": 0,
"qState": "L"
}
],
[
{
"qText": "[36054269.925000,66.225000,37857027.481250,35.112500]",
"qNum": 1,
"qElemNumber": 363266048,
"qState": "L"
}
],
[
{
"qText": "[55884603.043750,128.450000,57687360.600000,97.337500]",
"qNum": 1,
"qElemNumber": 1396244480,
"qState": "L"
}
],
[
{
"qText": "[14421179.250000,66.225000,16223936.806250,35.112500]",
"qNum": 1,
"qElemNumber": -68288512,
"qState": "L"
}
],
[
{
"qText": "[14421179.250000,252.900000,16223936.806250,221.787500]",
"qNum": 1,
"qElemNumber": 1949958144,
"qState": "L"
}
],
[
{
"qText": "[16223936.806250,97.337500,18026694.362500,66.225000]",
"qNum": 1,
"qElemNumber": 50462720,
"qState": "L"
}
],
[
{
"qText": "[19829451.918750,66.225000,21632209.475000,35.112500]",
"qNum": 1,
"qElemNumber": -1226702848,
"qState": "L"
}
],
[
{
"qText": "[21632209.475000,97.337500,23434967.031250,66.225000]",
"qNum": 1,
"qElemNumber": -1107951616,
"qState": "L"
}
],
[
{
"qText": "[7210149.025000,66.225000,9012906.581250,35.112500]",
"qNum": 13,
"qElemNumber": -1270087680,
"qState": "L"
}
],
[
{
"qText": "[7210149.025000,97.337500,9012906.581250,66.225000]",
"qNum": 3,
"qElemNumber": -765198336,
"qState": "L"
}
],
[
{
"qText": "[7210149.025000,128.450000,9012906.581250,97.337500]",
"qNum": 1,
"qElemNumber": -260833280,
"qState": "L"
}
],
[
{
"qText": "[9012906.581250,66.225000,10815664.137500,35.112500]",
"qNum": 7,
"qElemNumber": -2042363904,
"qState": "L"
}
],
[
{
"qText": "[9012906.581250,128.450000,10815664.137500,97.337500]",
"qNum": 2,
"qElemNumber": -1033109504,
"qState": "L"
}
],
[
{
"qText": "[10815664.137500,66.225000,12618421.693750,35.112500]",
"qNum": 3,
"qElemNumber": 1480327168,
"qState": "L"
}
],
[
{
"qText": "[12618421.693750,66.225000,14421179.250000,35.112500]",
"qNum": 2,
"qElemNumber": 708050944,
"qState": "L"
}
],
[
{
"qText": "[12618421.693750,128.450000,14421179.250000,97.337500]",
"qNum": 1,
"qElemNumber": 1717305344,
"qState": "L"
}
],
[
{
"qText": "[5407391.468750,66.225000,7210149.025000,35.112500]",
"qNum": 37,
"qElemNumber": 282591232,
"qState": "L"
}
],
[
{
"qText": "[3604633.912500,66.225000,5407391.468750,35.112500]",
"qNum": 76,
"qElemNumber": 1827143680,
"qState": "L"
}
],
[
{
"qText": "[1801876.356250,35.112500,3604633.912500,4.000000]",
"qNum": 1,
"qElemNumber": -1437597696,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,35.112500,1801876.356250,4.000000]",
"qNum": 8702,
"qElemNumber": -1946157056,
"qState": "L"
}
],
[
{
"qText": "[1801876.356250,66.225000,3604633.912500,35.112500]",
"qNum": 223,
"qElemNumber": 637534208,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,66.225000,1801876.356250,35.112500]",
"qNum": 7563,
"qElemNumber": 128974848,
"qState": "L"
}
],
[
{
"qText": "[3604633.912500,97.337500,5407391.468750,66.225000]",
"qNum": 10,
"qElemNumber": -1962934272,
"qState": "L"
}
],
[
{
"qText": "[3604633.912500,128.450000,5407391.468750,97.337500]",
"qNum": 6,
"qElemNumber": -1458569216,
"qState": "L"
}
],
[
{
"qText": "[5407391.468750,97.337500,7210149.025000,66.225000]",
"qNum": 6,
"qElemNumber": 787480576,
"qState": "L"
}
],
[
{
"qText": "[5407391.468750,128.450000,7210149.025000,97.337500]",
"qNum": 6,
"qElemNumber": 1291845632,
"qState": "L"
}
],
[
{
"qText": "[1801876.356250,97.337500,3604633.912500,66.225000]",
"qNum": 21,
"qElemNumber": 1142423552,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,97.337500,1801876.356250,66.225000]",
"qNum": 223,
"qElemNumber": 633864192,
"qState": "L"
}
],
[
{
"qText": "[1801876.356250,128.450000,3604633.912500,97.337500]",
"qNum": 11,
"qElemNumber": 1646788608,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,128.450000,1801876.356250,97.337500]",
"qNum": 53,
"qElemNumber": 1138229248,
"qState": "L"
}
],
[
{
"qText": "[7210149.025000,159.562500,9012906.581250,128.450000]",
"qNum": 1,
"qElemNumber": -8388608,
"qState": "L"
}
],
[
{
"qText": "[7210149.025000,190.675000,9012906.581250,159.562500]",
"qNum": 1,
"qElemNumber": 243793920,
"qState": "L"
}
],
[
{
"qText": "[9012906.581250,159.562500,10815664.137500,128.450000]",
"qNum": 1,
"qElemNumber": -780664832,
"qState": "L"
}
],
[
{
"qText": "[9012906.581250,221.787500,10815664.137500,190.675000]",
"qNum": 1,
"qElemNumber": -276299776,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,159.562500,1801876.356250,128.450000]",
"qNum": 7,
"qElemNumber": 1390673920,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,190.675000,1801876.356250,159.562500]",
"qNum": 8,
"qElemNumber": 1642856448,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,221.787500,1801876.356250,190.675000]",
"qNum": 2,
"qElemNumber": 1895038976,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,252.900000,1801876.356250,221.787500]",
"qNum": 1,
"qElemNumber": 2147221504,
"qState": "L"
}
],
[
{
"qText": "[1801876.356250,159.562500,3604633.912500,128.450000]",
"qNum": 2,
"qElemNumber": 1899233280,
"qState": "L"
}
],
[
{
"qText": "[1801876.356250,190.675000,3604633.912500,159.562500]",
"qNum": 2,
"qElemNumber": -2143551488,
"qState": "L"
}
],
[
{
"qText": "[3604633.912500,159.562500,5407391.468750,128.450000]",
"qNum": 2,
"qElemNumber": -1206124544,
"qState": "L"
}
],
[
{
"qText": "[3604633.912500,190.675000,5407391.468750,159.562500]",
"qNum": 1,
"qElemNumber": -953942016,
"qState": "L"
}
],
[
{
"qText": "[5407391.468750,159.562500,7210149.025000,128.450000]",
"qNum": 2,
"qElemNumber": 1544290304,
"qState": "L"
}
],
[
{
"qText": "[5407391.468750,190.675000,7210149.025000,159.562500]",
"qNum": 1,
"qElemNumber": 1796472832,
"qState": "L"
}
],
[
{
"qText": "[5407391.468750,221.787500,7210149.025000,190.675000]",
"qNum": 1,
"qElemNumber": 2048655360,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,284.012500,1801876.356250,252.900000]",
"qNum": 1,
"qElemNumber": -2021523456,
"qState": "L"
}
],
[
{
"qText": "[-881.200000,377.350000,1801876.356250,346.237500]",
"qNum": 1,
"qElemNumber": -1643249664,
"qState": "L"
}
],
[
{
"qText": "[1801876.356250,284.012500,3604633.912500,252.900000]",
"qNum": 1,
"qElemNumber": -1512964096,
"qState": "L"
}
],
[
{
"qText": "[1801876.356250,315.125000,3604633.912500,284.012500]",
"qNum": 1,
"qElemNumber": -1386872832,
"qState": "L"
}
],
[
{
"qText": "[5407391.468750,315.125000,7210149.025000,284.012500]",
"qNum": 1,
"qElemNumber": -1741815808,
"qState": "L"
}
],
[
{
"qText": "[5407391.468750,377.350000,7210149.025000,346.237500]",
"qNum": 1,
"qElemNumber": -1489633280,
"qState": "L"
}
],
[
{
"qText": "[12618421.693750,999.600000,14421179.250000,968.487500]",
"qNum": 1,
"qElemNumber": 448987136,
"qState": "L"
}
]
],
"qTails": [],
"qArea": {
"qLeft": 0,
"qTop": 0,
"qWidth": 3,
"qHeight": 51
}
},
{
"qMatrix": [],
"qTails": [],
"qArea": {
"qLeft": 0,
"qTop": 0,
"qWidth": 0,
"qHeight": 0
}
}
]
}
}
Information about the adaptive cell grid is returned.
Cells (group of points) are rendered and not points because the refinement level is too low. Therefore the values of the measures and the values of the dimension are not returned.
Concerning the adaptive grid cell:
- the maximum number of points in a cell is 8702 (in qNum of the first array).
- the coordinates (expressed in the measure range) are returned for each cell (in qText).
- the number of points in each cell is returned (in qNum).
- the identifier of each cell is returned (in qElemNumber).
Example 2:
The generic object contains two measures Sales and Loyalty and one dimension Customer.
In the case of the scatter plot visualization shown below, the level of details is high, so points are rendered.
The corresponding request from the client is:
{
"method": "GetHyperCubeBinnedData",
"handle": 6,
"params": [
"/qHyperCubeDef",
[
{
"qTop": 0,
"qLeft": 0,
"qWidth": 3,
"qHeight": 17017
}
],
{
"qWidth": 0,
"qHeight": 0
},
[
{
"qLeft": 11085992.444266044,
"qTop": 361.31534864125564,
"qWidth": 14131738.502861504,
"qHeight": 282.63477005723007
}
],
1000,
6,
0
],
"id": 23,
"jsonrpc": "2.0"
}
In the first array:
- qWidth is 3 because the generic object contains two measures and one dimension.
- qHeight is 17017 to render 17017 dimension values.
In the second array:
- qLeft gives the lowest value of the Sales measure.
- qTop gives the highest value of the Loyalty measure.
- qWidth gives the highest value of the Sales measure.
- (qTop- qHeight ) gives the lowest value of the Loyalty measure.
The maximum number of cells in the grid is 1000.
The level of details that is provided is 6.
The engine returns:
{
"jsonrpc": "2.0",
"id": 23,
"result": {
"qDataPages": [
{
"qMatrix": [],
"qTails": [],
"qArea": {
"qLeft": 0,
"qTop": 0,
"qWidth": 0,
"qHeight": 0
}
},
{
"qMatrix": [
[
{
"qText": "Rsl Contractors, Ltd",
"qNum": 0,
"qElemNumber": 4818,
"qState": "L"
},
{
"qText": "2.3201e+007",
"qNum": 23201033.97,
"qElemNumber": 0,
"qState": "L"
},
{
"qText": "82.4",
"qNum": 82.39999999999999,
"qElemNumber": 0,
"qState": "L"
}
],
[
{
"qText": "Khs&s Contractors",
"qNum": 0,
"qElemNumber": 2134,
"qState": "L"
},
{
"qText": "1.79704e+007",
"qNum": 17970402.81,
"qElemNumber": 0,
"qState": "L"
},
{
"qText": "83.2",
"qNum": 83.19999999999999,
"qElemNumber": 0,
"qState": "L"
}
],
[
{
"qText": "David Weekley Homes",
"qNum": 0,
"qElemNumber": 8790,
"qState": "L"
},
{
"qText": "1.59806e+007",
"qNum": 15980569.24,
"qElemNumber": 0,
"qState": "L"
},
{
"qText": "224",
"qNum": 224,
"qElemNumber": 0,
"qState": "L"
}
],
[
{
"qText": "Jdi Contractor & Supply",
"qNum": 0,
"qElemNumber": 4262,
"qState": "L"
},
{
"qText": "1.41034e+007",
"qNum": 14103439.920000002,
"qElemNumber": 0,
"qState": "L"
},
{
"qText": "108",
"qNum": 108,
"qElemNumber": 0,
"qState": "L"
}
]
],
"qTails": [],
"qArea": {
"qLeft": 0,
"qTop": 0,
"qWidth": 3,
"qHeight": 4
}
}
]
}
}
The first array ( "qMatrix": []) is empty because points are rendered. The refinement is high.
The second array returned the measure values and the dimension values for each point that is rendered.
The state is L for each cell. It corresponds to the default state for a cell.
Four points are rendered in total.