Hi,

I adopted the OpenFlashChartComponent Sample in my own dashboard. If I just insert the sample chart in my dashboard everything works fine. If I use a mdx query to my own data instead of the sample data also everything works fine. But if I use a sql query instead of mdx an error occures that the OpenFlashChart Component was not executed correctly. Is there any mistake in the following chart definition?

Code:
var MetaLayerOwn = {

ownChartDefinition: {
    width: "450",
    height: "350",
    chartType: "PieChart",
    datasetType: "CategoryDataset",
    includeLegend: false,
    title: "Test",
    queryType: 'sql',
    jndi: "dwh",
    query: function(){

        var query = "SELECT MATGR_L2 AS 'MATERIAL_GROUP', SUM(AMOUNT) AS 'AMOUNT'"+
                    " FROM dw_fact_sales_items2, dw_dim_material"+
                    " WHERE MC_SK = '6' AND dw_fact_sales_items2.MAT_SK = dw_dim_material.MAT_SK"+
                    " GROUP BY MATGR_L2;"
        return query;
    
    }
}
};

var own = 
{
    name: "Own",
    type: "openFlashChartComponent",
    chartDefinition: MetaLayerOwn.ownChartDefinition,
    htmlObject: "ownDiv",
    executeAtStart: true
};
Thanks in advance!