Skip to Content
avatar image
Former Member

Possibility of connecting multiple BW systems to single ECC system

Hi all,

I have a requirement in my company to connect multiple BW systems to single ECC system. Would like to confirm whether this may not be supported by all BW extractors in particular the delta mechanism?

For logistics extractor in ECC side in RSA7 it stores BW System as target which shows they support multiple BW systems as target, but for FI extractors which keeps delta timestamps in BWOM2_TIMEST table, it doesn't store the target system. I'm afraid if we connect multiple BW systems to single ECC system, some of the delta records might go to one BW system and some others go to the other BW system when we execute delta load in both BW systems.

Thank you very much in advance.

regards,

arie

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Jan 21, 2012 at 07:11 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2012 at 11:48 AM

    Hi,

    You can very well connect multiple BW systems to single ECC system and you will not miss any delta as well. In the source system for each delta data source a delta queue is maintained for each target system.

    for e.g. I have two BW systems ABW and BBW connected to AEC system then for 0FI_AP_4 data source we will have DQ1_ABW and DQ2_BBW as two different delta queues (I am not following any naming conventions, actual names will be as per the target system logical name).

    The settings maintained in BWOM2_TIMEST table are across the system and they define some global settings e.g. till what time the FI data should be extracted in BW system, for e.g. the time maintained is 2.00 AM then though you do extraction from multiple systems same data will be extracted till next time interval occurs.

    In summery you can very well connect multiple BW systems to a single ECC system.

    Regards,

    Durgesh.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 22, 2012 at 06:39 PM

    Hi,

    Yes, You can connect multiple BW system to single ECC system. In case of FI related data sources different delta queues are created for different target systems.

    Navesh

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2012 at 03:57 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 25, 2012 at 09:28 PM

    MULTIPLE BW system connected to one ECC is possible scenario. No issue with it not even with extractors.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2012 at 05:32 AM

    Thank you all. I found the official explanation from SAP regarding this in OSS Note 844222 - Two OR more BW systems against one OLTP system.

    Thanks once again.

    regards,

    arie

    Add comment
    10|10000 characters needed characters exceeded