Hypercube slow to display

[paulcalvet]

Hello,,

I have a mashup with a dashboard page which contains lots of hypercube : 42

Theses hypecubes show indicators, evolutions of these indicators, and indicators VS budget.

This page take 30 seconds to load, when I move to another page and I return on the dashboard page, it took 30 seconds again.

Which way is the best in order to accelerate the loading time ?

In my code, I have a function which create KPI with app.createcube :

function CreateKPI(app,GetWhat,GetDef,GetCallback) {
app.createCube({
"qInitialDataFetch": [
{
"qHeight": 1,
"qWidth": 1
}
],
"qDimensions": [],
"qMeasures": [
{
"qDef": {
"qDef": GetDef
},
"qLabel": GetWhat,
"qLibraryId": null,
"qSortBy": {
"qSortByState": 0,
"qSortByFrequency": 0,
"qSortByNumeric": 0,
"qSortByAscii": 1,
"qSortByLoadOrder": 0,
"qSortByExpression": 0,
"qExpression": {
"qv": " "
}
}
}
],
"qSuppressZero": false,
"qSuppressMissing": false,
"qMode": "S",
"qInterColumnSortOrder": [],
"qStateName": "$"
},GetCallback)
}

then I call this CreateKPI funtion 42 times :

CreateKPI(app,"GetBudgetVSObjPurchase","$(vCosts_VSOBJ_RATE_Y([Phase]={'Purchase'},[is budget]={1}))",GetBudgetVSObjPurchase);

And this is the function which display the KPI

function GetBudgetVSObjPurchase(reply, app){
var output = reply.qHyperCube.qDataPages[0].qMatrix[0][0].qText;
$("#GetBudgetVSObjPurchase").text(output);
}

Thanks !

Paul

[paulcalvet · Accepted solution]

Ok I found a solution.
I create 4 hypercubes with many measures inside.
I take one second to display the 42 KPIs now.