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.