SAP Process Chains Concept SAP BW
There are sometimes doubts regarding how to set up sap processes within the process chains. SAP 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 sap process chains:
SAP 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
Also See: Processing the Batch Input Session (SM35)