Skip to Content

DB Connect into BW


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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2016 at 01:24 PM


    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.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.