Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Use output of a dataset into another dataset(How to use output of a dataset into another dataset)
icon5.gif  Use output of a dataset into another dataset [message #684386] Wed, 15 June 2011 14:10 Go to next message
Krishan Babbar is currently offline Krishan Babbar
Messages: 2
Registered: June 2011
Junior Member
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 14:47 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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 06:25 Go to previous messageGo to next message
Krishan Babbar is currently offline Krishan Babbar
Messages: 2
Registered: June 2011
Junior Member
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 13:35 Go to previous message
Jason Weathersby is currently offline Jason Weathersby
Messages: 9167
Registered: July 2009
Senior Member

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:
  


Current Time: Sat Oct 25 12:54:42 GMT 2014

Powered by FUDForum. Page generated in 0.01810 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software