Enhance Process Chain Efficiency by Using Dynamic Delay Capability

  • by Michael Shtulaizen, SAP NetWeaver Technical Manager, Strauss Group Ltd., Israel
  • September 1, 2007
Use dynamic delays in process chains to optimize system efficiency by reducing system resources or by ensuring that gaps do not exist between sequential processes.
Key Concept

A process chain is a mechanism that controls extraction, transformation, and loading (ETL) activities execution at a scheduled time in a defined sequence. The process chain supports a tree model structure with a single root node that is responsible for process chain scheduling.

When using multiple process chains, you can face problems with the system executing them at appropriate times. Sometimes the system executes several process chains at once, slowing down the system. Or, process chains that are supposed to happen sequentially fail to execute at proper times, leaving long gaps between chain execution and causing inefficiency.

A process chain mechanism implemented in SAP NetWeaver BI supports a tree model structure with a single scheduler root node (Figure 1). This model does not cover complicated situations like that shown on the left side of Figure 2; in that case, you can decompose it to simple tree models that you can implement, as shown on the right side of Figure 2. I’m going to explain one of the ways to approximate an implementation for a real-life situation by dynamic delay capability.

Michael Shtulaizen

Michael Shtulaizen is the SAP NetWeaver technical manager of Strauss Group Ltd., Israel. He has been working with SAP BW since 2002. He has rich development experience in SAP environments (more than 10 years) that allows him to propose original solutions in SAP NetWeaver BW systems.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.