Process Chain is as follows
Start --> InfoPackage --> DTP[Load DSO] --> Activate DSO --> Delete Index[Infocube] --> DTP[Load InfoCube] --> Create Index --> RollUp Aggregate
Full Load, Delta Init and Initial Fill of Aggregates is done, the above Flow is for Loading Deltas.
Now my main Problem is that system gives and Error when I check the Process Chain.
It states that the Delete Index Process Type cannot be in front of an Aggregate Process Type.
I tried various combinations by placing the Delete Index Process Type before DTP[Load DSO], before InfoPackage but it still gives me the same Error.
Last thing what I did was Remove the Delete and Create Index Process Type from the Process Chain and Check, Bingo No Error.
Start --> InfoPackage --> DTP[Load DSO] --> Activate DSO --> DTP[Load InfoCube] --> RollUp Aggregate
Now my question is, "Are we not suppose to Drop and Create Index of an InfoCube when we have Aggregates defined on that InfoCube ?"
Will over the years when the size of InfoCube increases the Loading performance will degrade ?
Yes I think Loading of InfoCube will degrade and/or then How are we suppose to Handle the Delete Index Process Type when we are RollUp Aggregates in PC ?