Eclipse Community Forums: BIRT » Use output of a dataset into another dataset

Home » Archived » BIRT » Use output of a dataset into another dataset(How to use output of a dataset into another dataset)

Use output of a dataset into another dataset [message #684386]

Wed, 15 June 2011 10:10

Eclipse User

I have to create a report using output of 2 separate databases.

I have

Database A at system One
Database B at system Two
Table "Details" in database B having relationship with table "User" in database A
Table Details may have lakhs of records.

Schema of table "User"
Id
EncryptedId
UserName
etc.

Schema of table "Details"
EncryptedId
Address

EncryptedId is the only field showing relationship between both tables.

I have to show the following in my report, user will give his Id

Information from table User of Database A
+
Information from table "Details" of Database B

My problem is to fetch EncryptedId first from table "User" then use that in query fetching data from table "Details".

Please suggest the solution or let me know if my question is not clear.

Thanks
Krishan Babbar

Re: Use output of a dataset into another dataset [message #684439 is a reply to message #684386]

Wed, 15 June 2011 10:47

Eclipse User

Can you use a joint dataset?

Jason

On 6/15/2011 10:10 AM, Krishan Babbar wrote:
> I have to create a report using output of 2 separate databases.
>
> I have
>
> Database A at system One
> Database B at system Two
> Table "Details" in database B having relationship with table "User" in
> database A
> Table Details may have lakhs of records.
>
> Schema of table "User"
> Id EncryptedId
> UserName
> etc.
>
> Schema of table "Details"
> EncryptedId
> Address
>
> EncryptedId is the only field showing relationship between both tables.
>
>
> I have to show the following in my report, user will give his Id
>
> Information from table User of Database A +
> Information from table "Details" of Database B
>
> My problem is to fetch EncryptedId first from table "User" then use that
> in query fetching data from table "Details".
>
> Please suggest the solution or let me know if my question is not clear.
>
> Thanks
> Krishan Babbar
>
>
>

Re: Use output of a dataset into another dataset [message #684735 is a reply to message #684439]

Thu, 16 June 2011 02:25

Eclipse User

Yes Jason,
I can use Joint Dataset, but as per my understanding with Joint Dataset, I need to create total 3 datasets as given below.
1. First Dataset fetch data from table User for given Id
2. Second Dataset will fetch all the data from table Details.
3. Third would be Joint Dataset, which will fetch the required data

Now problem is second dataset. In this dataset it will first fetch all the records which can be in lakhs or more, which ultimately decrease the performance. So i want to avoid this performance degradation.

Am I right?

what you suggest as an alternative?

Thanks

Krishan Babbar

Re: Use output of a dataset into another dataset [message #684925 is a reply to message #684735]

Thu, 16 June 2011 09:35

Eclipse User

If you are trying to display user/details, you could make two datasets
one for users and one for details. The details dataset can be
parameterized like select * from details where userid = ?. Then add a
table to the report for users. Then nest the details table in the users
table. You can then select binding table for nested table and set the
value of the parameter for the query to the details. Does this make
sense. This will perform more queries though.

Jaosn

On 6/16/2011 2:25 AM, Krishan Babbar wrote:
> Yes Jason,
> I can use Joint Dataset, but as per my understanding with Joint Dataset,
> I need to create total 3 datasets as given below.
> 1. First Dataset fetch data from table User for given Id
> 2. Second Dataset will fetch all the data from table Details.
> 3. Third would be Joint Dataset, which will fetch the required data
>
> Now problem is second dataset. In this dataset it will first fetch all
> the records which can be in lakhs or more, which ultimately decrease the
> performance. So i want to avoid this performance degradation.
>
> Am I right?
>
> what you suggest as an alternative?
>
> Thanks
>
> Krishan Babbar
>

Previous Topic:	SLF4J Support
Next Topic:	use jndi with connection profile ?

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 18:06:00 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter