Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Joint data set using different data sources
Migrateduser
I have two different data sources that I want to join in a data set. The rows of one table contains values that I want to use for looking up rows in another table (from the other data source). I can create a joint data set and that works OK but it's very slow and unless I configure the JVM with a very large amount of memory it fails.
In a Java program I would solve the problem by using a parameter when looking up rows in the second table. The value of the parameter would be set from one of the columns in the first table. This approach is very quick and consumes very little memory.
I bet there's some way I can do this with BIRT but I haven't been able to find a good example. Any pointer would be greatly appreciated.
Thanks,
Thomas Hallgren
Find more posts tagged with
Comments
There are no comments yet