问Pentaho CDE :为堆叠条形图的每个条形图提供不同的数据源

EN

    function(){

 Dashboards.res=[];//will contain the result ; As for Pentaho 5.4 without RequireJS, Dashboards is a global varialbe, so that Dashboards.res is accessible eveywhere
 Promise.all([getib3(2016,3),getib3(2015,3),getib3(2016,8)]).then(
     function(r){
//res contains the result of the 3 queries
       console.log(res);
       Dashboards.etComponentByName('render_mychart').update(); //Activates the chart
    },
    function(err) { 
        console.error(err);
    }     
);
function getib3(a,m){
          var postquery='path=%2Fhome%2myhome%Ftestpromise.cda&dataAccessId=sql_get_ib3&paramparam_annee='+a+'&paramparam_mois=' +m;
        $.ajax({
                        url:  '/pentaho/plugin/cda/api/doQuery?',
                        type: 'POST',
                        dataType: 'json',
                        data: postquery,
                       // async:false,
                     }).done(function (data) {   console.log(data)  ;
                           res.push(data.resultset);//ad the result of the query

                        }).fail(function ( jqXHR, textStatus, errorThrown) {
                        alert('query :' + textStatus);
                        });
}
} 

function(d) {//d is the resultset of the dummy datasource, here we can ignore it.
       return (Dashboards.res); //We override d with the resultset we build above
}