Paging Data from Hypercube

Mon, 10 Jul 2017 05:19:13 GMT

Hi ,

We have a req to build get data from a hypercube, the base dataset contains around 5000 rows .Using the Mashup API we are able to get all the rows in one go, but we want to get the data in pages so as to improve performance of the webpage.

If anyone has done this using the mashup api please suggest.

Thanks.

Here's the code we are using to get data

app.createCube({

"qInitialDataFetch": [

{

"qTop":0

"qHeight": height,

"qWidth": 2

}

"qDimensions": [

{

"qDef": {

"qFieldDefs": [

"time_key"

]

"qNullSuppression": true,

"qOtherTotalSpec": {

"qOtherMode": "OTHER_OFF",

"qSuppressOther": true,

"qOtherSortMode": "OTHER_SORT_DESCENDING",

"qOtherCounted": {

"qv": "5"

"qOtherLimitMode": "OTHER_GE_LIMIT"

}

"qMeasures": [

{

"qDef": {

"qDef": "count(post_id)"

"qLabel": "count(post_id)",

"qLibraryId": null,

"qSortBy": {

"qSortByState": 0,

"qSortByFrequency": 0,

"qSortByNumeric": 0,

"qSortByAscii": 1,

"qSortByLoadOrder": 0,

"qSortByExpression": 0,

"qExpression": {

"qv": " "

}

"qSuppressZero": true,

"qSuppressMissing": true,

"qMode": "S",

"qInterColumnSortOrder": [],

"qStateName": "$"

},callTimeKey);

function callTimeKey(reply){

var valueDimension = [];

var valueMea = [];

console.log(reply);

$.each(reply.qHyperCube.qDataPages[0].qMatrix,function(index,value){

valueDimension.push(this[0].qNum);

valueMea.push(this[1].qNum);

});

$.each(valueDimension,function(index,value){

console.log(valueDimension[index]);

});

$.each(valueMea,function(index,value){

console.log(valueMea[index]);

});

}

topic Paging Data from Hypercube in Connectivity & Data Prep

Paging Data from Hypercube