cancel
Showing results for 
Search instead for 
Did you mean: 

Join using the same table

former_member654002
Participant
0 Kudos

Hi BO Gurus,

I am starting using Business Objects

I am using Information Design Tool and i need to create a join using the same table.

I have a table with the following lines

                  Field1           Field2           Fielf3

                   991              HR1        

                   992              SUP             HR1

I need a result like this:

                  991               HR1            SUP     992

How can i obtain that in a report?

I tryed to  create an alias or a derivate table but i get the message.

This connection supports only detection based on database keys.

Can someone give some advices for this question?

Thank you and best regards

João Lages Fernandes

Accepted Solutions (1)

Accepted Solutions (1)

nscheaffer
Active Contributor
0 Kudos

What BI support pack and patch are you on?  What database are you connecting to?

Noel

former_member654002
Participant
0 Kudos

Hi Noel,

Thank you for your reply.

The version is 4.1 SP2. The database is Oracle using SAP infoset's.

Best regards

João Lages Fernandes

nscheaffer
Active Contributor
0 Kudos

I have only ever connected to Microsoft SQL Server.   Could you create a view in the database that joins back to itself and then reference that view in the Information Design Tool.

Noel

Answers (0)