Cartesian product of datasets

Is it possible create a dataset which is the cartesian product of two other datasets in BIRT. My datasets are small ie 30 rows and 10 rows. I need to do this to create the data I need for a datacube -> joins just don't do it for me.

Thanks.

Find more posts tagged with

Comments

mwilliams

Hi Stuart,

What does the data in your two different dataSets look like? What do you want the final dataSet to look like? Let me know, I'll try to help. Thanks.

stuart

Hi Michael,

The datasets relate to the crosstab report and the missing data you rightly mention in another thread. Here are the two data sets that I'm trying to create a cartesian product from:

dataset 1

Community 2ME
Community 2NBC
Community 2SSR
Community Other
Community PVR
Community Radio 50+
Community WOW FM
Metropolitan 2SM
Metropolitan 2UE
Metropolitan 702 ABC
Metropolitan ABC Radio
Metropolitan Channel 10
Metropolitan Channel 7
Metropolitan Channel 9
Metropolitan Daily Telegraph
Metropolitan NOVA
Metropolitan Other
Metropolitan SMH
Metropolitan Today Show
Metropolitan Vega FM
Regional ABC Mid North Coast
Regional ABC Newcastle
Regional KO FM
Regional Other

dataset 2

01/08/09
02/08/09
03/08/09
04/08/09
05/08/09
06/08/09
07/08/09
08/08/09
09/08/09
10/08/09
12/08/09
13/08/09
14/08/09
15/08/09
16/08/09
17/08/09
18/08/09
19/08/09
20/08/09
.
.
.
31/08/09

Cartesian product

01/08/09 Community 2ME
02/08/09 Community 2ME
03/08/09 Community 2ME
04/08/09 Community 2ME
05/08/09 Community 2ME
06/08/09 Community 2ME
07/08/09 Community 2ME
08/08/09 Community 2ME
.
.
31/08/09 Community 2ME
01/08/09 Community 2NBC
02/08/09 Community 2NBC
03/08/09 Community 2NBC
04/08/09 Community 2NBC
05/08/09 Community 2NBC
06/08/09 Community 2NBC
07/08/09 Community 2NBC
08/08/09 Community 2NBC
.
.
31/08/09 Community 2NBC

etc

Thanks.

stuart

Hi Michael,

Is this possible via BIRT?

Thanks.

mwilliams

Stuart,

I haven't done this, but you might be able to do this with a scripted dataSource/dataSet. If you call the data in using java/javascript, I would imagine you could pair it however you wanted.

stuart

thanks Michael. That is the approach I have taken.