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
