JOINS IN BUSINESS OBJECTS

building reports webintelligence
1

How do you create left, right, inner, outer joins in Business Objects, assuming that: (1) I am NOT a Universe designer and only a report developer, (2) I am a Universe desginer.

Thanks in advance!

ANIVID (BOB member since 2009-09-12)

2

Sounds like an interview question.

You can’t do it if you are not allowed to use Designer, unless you want to create a Free Hand SQL report.

Double click the join between the two tables in the Designer, rest is obvious.

zack :us: (BOB member since 2007-08-02)

3

Hi ANIVID,

Can you please let us know what you are trying to achieve? Which specific problem are you having difficulties with?

Marek Chladny :slovakia: (BOB member since 2003-11-27)

4

Hi Marek,

Thanks for asking.

The problem I have is this:

I am trying to create an exception report that will list all check payments that do not have any payment vouchers. Check Payment reference numbers can be linked (outer left join) to the Payment Voucher transaction numbers. The Check Payment reference numbers are on the left table. If the Check Payment reference number is on the list but the corresponding Payment Voucher field in the right table is null, then it means the check payment does not have any payment voucher.

I hope you or any one who reads this can help me, since I am very new to BO XI. By the way, I am a report developer and does not design universes.

Thanks, everyone!

ANIVID (BOB member since 2009-09-12)

5

Have the Universe Designer create the outer join for you. In the report, you need add a condition in the query panel( Payment Voucher = "null’), which will ad that condition as a where clause to the query generated by the report. For more information on how to add conditions to report, please refer to the Web Intelligence guide.

zack :us: (BOB member since 2007-08-02)

6

Then your option are limited only to creating reports based on free-hand SQL or to customizing the query that BO generates for you in Webi/Deski. None of this is a good (in terms of sustainable) way to go.

So you need to ask your BO universe developer to create outer/left/right joins in the universe for you.

Marek Chladny :slovakia: (BOB member since 2003-11-27)