Wednesday, August 25, 2010

How to properly design process chains

There are sometimes doubts regarding how to set up processes within the process chains. Process chain is structural and logical grouping of processes , jobs or steps involved within loading of data into BW. Proper design of chain has effects on its performance and consequently on performance of whole BW system. Therefore kind of best practice I can recommend following sequence for designing process chains:

a.    Delete Index
b.    Data Transfer Process / Execute InfoPackage – optimally in parallel
c.    Generate Index
d.    Construct Database Statistics
e.    Compress cube
f.     Delete PSA (aged data requests)
g.    Delete Change Log (aged data requests)

Here’s quite obsolete picture from SAP presentation material depicting loading process in BW 3.0.

No comments: