Help!! how to create inner & outer joins in designer

[lathasury]

Hi,

I am very new to designer, I used to work on oracle discoverer which me create inner and outer joins between 2 columns and provided an option to the user to pick what join the needed to use and I need to imitate this. For. E.g

Table A Table B
-------- -------

Ndc Ndc
Charge Bn
... ...

I need to set up 2 joins
(a) A.ndc = b.ndc (name it as inner)
(b) A.ndc = b.ndc (+) (name it as outer)

How do I set this up in designer..I tried creating 2 joins as mentioned above but when you look in business objects, the query selects both joins instead of one...is there a way I can choose thw joins I need. Please help!!!

Thanks,
Latha

 

[blom0344]

Hello Lathasury,

Personally I have no experience with tables both joined by an inner AND an outer join (can't visualize any need for such a construction), but it does point a bit to what in designer's terms is called "Context". By defining a context you can specify which tables/joins should be taken into account for a certain query-path.

In practical terms: when you set-up a universe with contexts defined in them , the end-users will be confronted by a prompt about which context he wants to use when he defines a query that concerns multiple paths.

Perhaps a quick view in Designers Guide (Chap 6.) will give you a better idea if this is something you can use.