Hi,
I have a requirement where data from third party source system(thru DB connect) should be staged and reported in BW/Bex. There are more than 30 tables involved in Source system and i know their relationships as well to create 10 reports as user needs.
Now i need to give solution architecture to stage this data in BW before going for the reporting in Bex. Please help me to know how many DSOs, Cubes etc.., i need to stage these data for better modelling in BW.
Hi,
it depends on several factors and requirements to decide what type of Infoproviders you want to use. Whether you want to keep history, or report on DSO etc.?
It is possible that if you have 30 tables you can define first the fields that you really need for reporting and the master and transactional data that is to be reported. Then you start building infoobjects in SAP BW side and load this data. Then you can use Infocubes to load transactional data from DSOs. Finally you can use multiproviders.
Please check in google/scn for the LSA Architecture Concept and you will learn more about data modelling.
Regards,
Regys
Add a comment