How to get Left outer Join in SAP IDT

building semantic layer
1

Hello all,

I am creating new IDT with two tables T1 and T2.

The join between two tables is T1.ID=T2.ID. I selected left side outer join check box(My meaning is to get everything from T1 table and matched records from T2)

When I view the sql script(after saving the dfx), I see a right outer join(designer just shifted tables left to right and made as right outer join) There is nothing wrong with query but I just like to see left outer join.

I tried enabling ANSI92 to yes based on BOBJ forum suggestions but so far no luck.

NMlakshmi (BOB member since 2017-10-24)

2

you would need to move the tables probably (i.e. drag and drop) in the dfx

erik.stenson :us: (BOB member since 2012-07-30)

3

I tried to move left table to right, right table to left,checked and unchecked both side of outer joins.Not changed anything…

Thanks for your reply!!

NMlakshmi (BOB member since 2017-10-24)