Multiple DataTargets in the Same BI 7.0 System to One DataSource

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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...