DataFlow of Process Chains in different SAP BW-BI

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)


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 ).

Start

\/
Infopackge1A(Attr)Infopackge2A(Attr)
\/
Infopackge1B(Txts)Infopackge2B(Txts)
/_____________________
Infopackge1C(Txts)______
\_____________________
_\____________________
__\___________________
___\__________________
_____\________________/
______ _And Processor__ ( Connect Infopackge1C & Infopackge2B )
____________________
Attribute Change Run ( Add InfoObject 1 & InfoObject 2 to this variant )

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 for Cube

1 comments:

arjun said...

Hi Sharath,
Nice Artical on Process chain, Can you explain me Attribute change run with Scenarios