DataFlow of Process Chains in different SAP BW-BI

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)


DataFlow of Process Chains in different SAP BW-BI
Steps for Process Chains in BI 7.0 for a Cube.
1. Start
2. Execute Infopackage
3. Delete Indexes for Cube
4.Execute DTP
5. Create Indexes for Cube

For DSO
1. Start
2. Execute Infopackage
3. Execute DTP
5. Activate DSO

For an IO
1. Start
2.Execute infopackage
3.Execute DTP
4.Attribute Change Run

Data to Cube thru a DSO
1. Start
2. Execute Infopackage ( loads till psa )
3.Execute DTP ( to load DSO from PSA )
4.Activate DSO
5.Further Processing
6.Delete Indexes for Cube
7.Execute DTP ( to load Cube from DSO )
8.Create Indexes for Cube
SAP BW 3.X

Master loading ( Attr, Text, Hierarchies )

Steps :

1.Start
2. Execute Infopackage (say if you are loading 2 IO's just have them all parallel )
3.You might want to load in seq - Attributes - Texts - Hierarchies
4.And ( Connecting all Infopackages )
5.Attribute Change Run ( add all relevant IO's ).


1. Start
2. Delete Indexes for Cube
3. Execute Infopackage
4.Create Indexes for Cube
For DSO

1. Start
2. Execute Infopackage
3. Activate DSO

For an IO

1.Start
2.Execute infopackage
3.Attribute Change Run

Data to Cube thru a DSO
1. Start
2. Execute Infopackage (Loads till PSA)
3.Activate DSO
5.Further Processing
6.Delete Indexes for Cube
7.Execute Infopackage
8.Create Indexes forCube