Extract data into two BW systems

[former_member636372]

Hello,

This is a question regarding extracting data from one OLTP system connected on two BW systems.

I need to send some of the data records only into the first BW system and some of the data record only into the second BW system.

In the extractor user exit EXIT_SAPLRSAP_001 (INCLUDE ZXRSAU01) I don't have information which BW system performs currently the data extraction.

Is there any other possibility to filter data on OLTP before sending them into BW ?

Thanks for your help !

Igor

Edited by: IFR on Jun 18, 2008 6:03 PM

[Former Member · Accepted solution]

The 2 different BW systems would have 2 different RFC users that logon to R/3 while requesting data...

let's say : BWREMOTE1 and BWREMOTE2

do the check first as to which user is trying to access the exit..

If its BWREMOTE1 requesting data get into INCLUDE# 1 which would have the logic to send only the records that you want...

If its BWREMOTE2 then go into INCLUDE#2

Assign points if it helps

Edited by: KK on Jun 18, 2008 1:13 PM

[Former Member · Accepted solution]

That should work. Kudos!

[former_member636372 · Accepted solution]

Yes, this will definitely solve the problem.

I didn't want to have a technical RFC user to be hardcoded in extractor, but it seems to be the simplest way to differ between BW systems without any modification in extractor program ...

Unfortunately SAP does not provide enough information in the interface ...

Thanks to you both !

Please replay if there are any other ideas ...

[Former Member]

You need to set up two target systems in R/3 (one for each BW system). The EXIT_SAPLRSAP_001 will work when filling the data for both systems. If you need to filter the data going to either system, it is better to filter in the BW system than in R/3, unless you set up a unique datasource in R/3 for each BW system.

Does this help?

[former_member636372]

Why it is better to filter in the BW system rather than in R/3 ?

I would like to avoid any changes in BW, because of:

- reducing data traffic

- in the source system we have more data(fields), that can be used as filter in EXIT_SAPLRSAP_001

The data sources are unfortunately the same for the both BW systems, so I cannot differ between them.

What do you think about these solutions:

1. Modification in the source system - to pass logical system of BW into EXIT_SAPLRSAP_001 (the logical system is available just before EXIT_SAPLRSAP_001 is called, but unfortunately is not passed as parameter)

2. Pass some dummy selection parameter from BW just to identify BW system ...

May be any other solutions ?