This website is not affiliated with, sponsored by, or approved by SAP AG.

multiple joins in sap bw ?

Business Warehouse

Moderators: Snowy, thx4allthefish

multiple joins in sap bw ?

Postby anya_nanda » Mon Nov 12, 2012 5:41 pm

Hi all

We have a requirement to replicate data and report on it from a 3rd party system which
is based on access DB.

In Access they have a view based on 4 tables

Table-A
Table-B
Table-C
Tabke D

This view has multiple Join conditions implemented as below

Join 1 :Table-A Field 1 = Table B Fields 1 left outer
Join 2: Table-B Field 2 = Table C Field 1 left inner join
Join 3: Table-B Field 3 = Table-C Field 2 left inner Join
Join 4: Table-B Field 2 = Table-D Field 1 left inner join
Join 5: Table-B Field 4 = Table-D Field 2 left inner join
Join 6: Table-C Field 5 = Table-D Field 3 left inner join


I have already replicated the 4 tables in BW. How can I implement
the logic of the 5 joins in BW. I know I can use generic DS based
on FM or views. However, I am not sure how to achieve the join
functionality.

I have other requirements with a mix of L/R inner, L/R outer joins.
Please provide me ideas on how I can implement such requirements in SAP BW

thanks all
anya
anya_nanda
 
Posts: 60
Joined: Tue Oct 07, 2003 3:45 am

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 3 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.