How to bind datacube data to a highcharts heat map in a custom visualisation?

Hi there. 
I have some time series data with measurement values that are organised in a data cube. 
I would like to use the highchart heatmap in a custom visualization to visualize this data cube. 
Moreover, I would like to drill up/down along the time levels. 
How can I achieve the data binding at all? 
The actuate.XTabAnalyzer class always seems to require an html viewer. 
I have found no JSAPI functions to access the underlying cube data without using the html viewer. 
Is there a way to access the cube data and feed it into a custom visualization such as the heatmap without displaying the viewer? 
If I cannot use the actuate.xtabanalyzer.Driller class: How can I drill up/down the datacube dimensions ? 
Some design advice is appreciated.Of course, some example report would be even better.
 
I am using BIRT 3.1 with Actuate Java Components as a runtime. 

Thanks, Peter

Find more posts tagged with

Comments

Peter W

Hi there,
 
eventually, it was sufficient for me
<ol><li>to work with a standard BIRT scatter chart (instead of the heat map)</li>
<li>to take the primary collection of the data cube</li>
<li>to use the standard aggregation features for charts with time categories in combination with a before factory trigger.</li>
</ol>Using the before factory trigger with a report parameter for the desired aggregation interval allowed me to dynamically change the aggregation level as originally intended with the drill down/up mechanism of the data cube.
 
Rgds. Peter
 
before factory trigger: 
importPackage(Packages.org.eclipse.birt.chart.model); 
importPackage(Packages.org.eclipse.birt.chart.model.attribute); 
rptDesignHandle = reportContext.getReportRunnable().designHandle.getDesignHandle(); 
chart = rptDesignHandle.findElement("mongochart"); 
item = chart.getReportItem(); 
cm = item.getProperty("chart.instance"); 
xAxis = cm.getAxes().get(0); 
xSeriesDef = xAxis.getSeriesDefinitions().get(0); 
xGrouping = xSeriesDef.getGrouping(); 
if (params["Group"].equals("Minutes")) { 
 xGrouping.setGroupingUnit(GroupingUnitType.MINUTES_LITERAL); 
} else if (params["Group"].equals("Hours")) { 
 xGrouping.setGroupingUnit(GroupingUnitType.HOURS_LITERAL); 
} else if (params["Group"].equals("Days")) { 
 xGrouping.setGroupingUnit(GroupingUnitType.DAYS_LITERAL); 
} else if (params["Group"].equals("Weeks")) { 
 xGrouping.setGroupingUnit(GroupingUnitType.WEEKS_LITERAL); 
} else if (params["Group"].equals("Months")) { 
 xGrouping.setGroupingUnit(GroupingUnitType.MONTHS_LITERAL); 
} else if (params["Group"].equals("Years")) { 
 xGrouping.setGroupingUnit(GroupingUnitType.YEARS_LITERAL); 
} 
xGrouping.setGroupingInterval(params["Groupintervall"].value);

rajani_interwove

Hi,
 
Can you please send an example report which show binding a data cube to a chart.
 
Regards,
rajni