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

Raising an event at the end of a process chain

Posted on Oct 15, 2003 at 01:10 PM 14 Views

Hi everbody,

I would like to fire an event at the end of a process chain that loads data into a InfoCube. This is not supported with BW 3.0B. The formerly used InfoPackagesGroups have supported to submit an event at the end of the group to start subsequent jobs,

The reason is that I have 4 different process chains. Each loads transaction data from a source system to the same InfoCube. These load streams are completly independent from each other and are started by the source system over an event with the program SAPEVT. If all 4 streams have finished successfully I would like to fire an event (with the old event collector). This event should start the stream with the rollup and statistic jobs. That way I can bring the independent streams together again. This allows me to have smaller process chains that are not that complex and are vere loose coupled. I don't want to wait until every system has delivered the import files to start the complete load stream in one process chain..

The only way I see at the moment is to write an ABAP program to send the event or I implement an own process type (-> seems to be not that easy).

Has anyone an idea how to solve that problem?

Kind regards,

Hansjörg Luzi

Graubündner Kantonalbank

CH-7002 Chur

Mail: hansjoerg.luzi@gkb.ch

BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Alexander Peter
    Alexander Peter
    Posted on Oct 22, 2003 at 01:51 PM

    Hello Mr. Luzi,

    why don't you use a meta process chain which controls the complete process and calls the detailed process chains (one for loading, one for roll-up etc.)? I would not use events to start another process chain, but rather use the control and monitoring mechanism inside the process chain functionality.

    Kind Regards,

    Alex PETER, SAP AG, Product Management BI

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Oct 22, 2003 at 06:42 PM

      Hi Mr. Peter

      I think that's not the solution for my problem. I couldn't wait until each source system has delivered the flat file for the load. These systems are completly independent from each other (running at different time) and I want to load the data into the InfoCube as soon as the file is ready.

      In the case of a problem with the extraction process in one of the source systems I do not want to wait with the load til the bug has been corrected. The flat file are very big (> 1 Mio. records each) so time is important. That's the reason why I would like to have 4 independent process chains that I have to join together and continue with the rollup and runstats.

      There have to be a way to do something like that due to the growing number of data sources they have to be loaded into the InfoCube. Otherwise the process chains would be very complex.

      Thank you anyway for your help.

      Kind regards

      Hansjörg Luzi

      Graubündner Kantonalbank

      CH-7002 Chur