Paging Data from Hypercube

[#1]

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]);

});

}