Java Chart library for OLAP

Question

Dear All,

Is there any java chart library that supports OLAP data, like ChartFX Olap or Dundas Chart ?

Thanks

Answer 1

JFreeChart or JasperReports would be my recommendations.

Answer 2

Hi duffymo,

Thanks for your answer. I already tried JFreeChart, but it doesn't seems support bar chart like Dundas Chart does.

Answer 3

jCharts: http://jcharts.sourceforge.net/ is one I have used in the past.

Answer 4

Here is the obligatory google solves that answer: Google Charts.

http://code.google.com/apis/chart/

However, these will not be hosted on your system. I'm also not sure they support post request types, so the amount of data you can send is limited to the size of a get request url.

Answer 5

To echo what others have said, yes, the Google Chart API may provide a lightweight solution along with a Java wrapper API like charts4j (disclaimer: I wrote charts4j). To see a complete listing of all Google Chart wrapper APIs, see here.

Answer 6

In order to display any data as a chart, it will need to be reduced to a 2D recordset - which is what OLAP gives you when you run an MDX query.

If you've got that 2D data, you can pass it to any chart/graph code really.

I used to use ASP to run the MDX, and write out XML. This was turned into a chart with client-side JavaScript. I wrote the lot myself and it was a nightmare! Use Google charts or Flot.