how to trigger process chain when datasource is loaded with new data? PUSH

[Former Member]

Hi all,

Till now we use the pull method to load data in BW which is done manually......but we would like to work with the PUSH method where whenever new data is loaded in the datasource an event is triggered which inturn triggers the process chain...

how is this possible? can we do this on a timestamp on the datasource to trigger the event?

rgds,

wills

[Former Member]

If the datasource is in R/3, you can always trigger an event in BW from R/3. If you have a batch job in R/3 that fills your datasource, or finishes loading delta queues (LO), you can add a step to your batch jog to trigger an event in BW. Then create a process chain in BW that starts based on the triggered event. The process chain can then execute your infopackage(s) to load your data into BW.

Refer to this link if this helps:

BTW, welcome to SDN!

[Former Member]

hi Geo,

Thanks for ur response. I appreciate it.

The case is slightly different. I am working on Bank analyzer data which is residing in a source system defined to load the results from the Results DataBase, a part of the Bank analyzer.

If it was R3 we have the standard calling procedures...but now the data in not in R3 but in Bank analyzer.

I am keen to look at some procedure to push the data automatically whenever an end user execution is done at the BA level into the BW.

ur help would be highly appreciated....

thks,

rgds.

wills

[Former Member]

There is a command on the BW application server (outside of BW) called <b>sapevt</b>. You can use this to trigger an event in BW.

See this:

<a href="http://help.sap.com/saphelp_nw04s/helpdata/en/fa/096e6b543b11d1898e0000e8322d00/frameset.htm">Trigger event in BW from outside BW</a>

Also try to search this forum for "sapevt" to get other ideas. Maybe you can create a Shell script to call the sapevt command from your Bank Analyzer server.

Hope this helps.

[Former Member]

Thank you very much guys...I appreciate the help.

thks,

rgds,