Skip to Content
0
Former Member
Sep 08, 2007 at 05:37 AM

Best way to join information from two datasources??? pls help

23 Views

Guys Please help in understanding the basics of modelling in terms of best practises in SAP-BI

I have two datasources. One is standard Bussiness content datasources 2LIS_02_ITM ( having PO item level data) and the other is a generic datasource on table EBAN (having PR details). Now all my report requirements are on both PO and PR information.So i need to club these datasources or its corresponding DSO's or its corresponding cubes.

Please suggest the best of the following solutions:

solution 1 and 2

-


2LIS_02_ITM -


> DSO1 -


> PO cube

Gener Datasourceon EBAN -


> DSO2----


> PR Cube

solution one is to go and build multiprovider joining with PR no in either cubes

solution two is to go and build infoset joining with PR no in either cubes

solution 3

-


2LIS_02_ITM -


> DSO1 -


> cube

Gener Datasourceon EBAN -


> DSO2

while populating data from DSO1 to cube we lookup on to DSO2 and read the PR data , thus consolidating both PR and PO data in the cube

solution 4

-


Here i can plan to combine two datasources 2LIS_02_ITM ,Gener Datasourceon EBAN into one infosource.

(2LIS_02_ITM ,Gener Datasource on EBAN)---- >infosource ->DSO -->cube

solution 5

-


i can club both PO and PR information at the r/3 side only into a view and build a generic datasource on that... then bring the whole data into one DSO and cube and report on that....

Please do help me guys.... i will award points to all who adds some imp information.