Handling a lot of data series in one chart

Hello BIRT experts.

I have the challenging task of drawing no less than 6 data series in a single chart. As I am still quite unexperienced with BIRT I'm sorting out how to do this in an elegant fashion.

The only option I have found so far is to use a mega-join, but this is somewhat ugly. As my data series are somewhat scattered in the database (using several fact tables and views) this is not quite what I want. Moreover, this would result in an enormous number of columns: 6 fact columns + a few metadata columns for each data series = ~20 columns

So is there another option for including 6 data sets in a single chart, like using multiple data sets in a chart?

Kind regards
Frank

Find more posts tagged with

Comments

mwilliams

Hi Frank,

I'm pretty sure there's gonna be no way to do it without joining the dataSets together. I've been wrong before though.

fbrueseke

Hi,

I was hoping for a more elegant solution...

So if a huge join is my only option:
What is better using Joined datasets in BIRT or joining data together in the SQL-query?
Are joined datasets as fast as SQL-level joins?

Kind regards
Frank

mwilliams

Frank,

I would assume that SQL level joins would be faster as they don't require processing by BIRT. However, I'm not sure what the magnitude of this time would be. I'm guessing testing would be the only way to figure that out.