Skip to Content
author's profile photo Former Member
Former Member

Multiple DataTargets in the Same BI 7.0 System to One DataSource

Currently, I do not have access to BI 7.0 system. I am wondering whether it is possible to connect MULTIPLE DataTargets of a single BI 7.0 system to ONE DataSource in the source system? I have searched the forum, but I couldn't find relevant posts. If I am not wrong, until BW 3.5, once a DataSource is assigned to an InfoSource, it can not be assigned to any other InfoSource of the same BW system. I have heard that this has changed in BI 7.0 with the new DataFlow concept.

The current requirement is that multiple DataTargets of a single BI system need to get DELTA data from the same DataSource in the source system. If this is technically possible in BI 7.0, should the source system also support such an assignment (since the DELTA load timestamps are maintained in the source system)? What source systems currently support this feature, if any? What are the appropriate tables in the source system that I need to look at to do further investigation?

All the useful inputs regarding these questions will be rewarded with points. Thanks!

Sameer

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 13, 2008 at 05:06 PM

    Dear,

    You can connect MULTIPLE datatargets to a SINGLE datasource.

    Each data target will have a separate Transformation to connect between the PSA and the data target.

    So, if you have say, 5 data targets, there will be 5 data targets from a single PSA.

    so the flow ideally would be as follows:

    Datasource >through infopackage >psa >through transformation(5 different) >data targets(5 different).

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 13, 2008 at 07:27 PM

    Currently, I do not have access to BI 7.0 system. I am wondering whether it is possible to connect MULTIPLE DataTargets of a single BI 7.0 system to ONE DataSource in the source system?

    Yes, it is possible.

    Transformations and DTP's are Source - Target specific.

    The current requirement is that multiple DataTargets of a single BI system need to get DELTA data from the same DataSource in the source system. If this is technically possible in BI 7.0, should the source system also support such an assignment (since the DELTA load timestamps are maintained in the source system)?

    Data is extracted into PSA from the sourcesystem and is taken from there to different targets connected using diff transformations. If the datasource works on timestamp then it all depends on how the data is transformed to diff targets from PSA.

    What source systems currently support this feature, if any?

    ECC, irrespective of sourcesystem it all depends on how the datasource functions as data is only extracted till PSA.

    What are the appropriate tables in the source system that I need to look at to do further investigation?

    Datasource properties - ?? ROOSOURCE...

    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.