Skip to Content

Setup 2LIS* datasource in 2 BW system

Dear Expert,

Currently my ERP 6.0 system connects to a BI 7.0 system. I am planning to connect my ERP 6.0 to one more BW system which is running in 7.40.I found SAP support multiple BW systems connect to single ECC source system but I also found there are some limitations for some data sources. I find a note 1932459 BW DataSource: Loading of data into multiple BW target systems is not supported.

It seems datasource 2LIS_*only permit to load data into a single BW target system.I just wonder did anyone has experience to connect one ECC system to multiple BW systems and somehow you found a work around to make datasource and 2LIS_*work such as 2LIS_03_BF, 2LIS_03_UM and 2LIS_03_BX?

Actually I already tried to set up the 2LIS_* datasource in my 2 BW system. When I tried to run the setup job OLI1BW for 2LIS_03_BF, I keep getting a message - 2LIS_03_BF still contains data still need to be transferred. I believe the message is telling me there are some data in the delta queue or in SM13. However, I can’t clean up those data since those data is for my old BW system. If I clean it up, I am afraid my old BW system will lost some delta data.Can I just ignore the message and continue to set it up but will it causes trouble for my old BW system?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 05, 2016 at 02:29 PM

    What you can try is clear the delta queue by extracting the outstanding records into your old BW system (just run the delta infopackage for the relavent extractors once or twice). The total should be zero in source system RSA7 (BW delta queue). once this can be achieved you can continue with your configuration of BW2 system.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2017 at 12:28 PM

    An alternative approach is to change to "direct delta" in LBWE, after processing the lbwe jobs.

    The delta queue in RSA7 gets updated directly and this queue is already specific for each bw target.

    Hope it helps.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2017 at 12:39 PM

    Hi Jason ,

    We have an option to load data from one source to Multiple targets.Coming to your scenerio you want load Standard 2LIS * ds to your target suppose if there are already any flow exist then it will disturb your Question is this right.

    If that is the case we have already replicated that DS to sap bw we have to just create an Export DataSources on that and load the data to required next level target.

    That's it.

    Regards

    SurendraP

    Add comment
    10|10000 characters needed characters exceeded