Activating data in an ODS takes a very long time.
Bad performance (4/5 hours) during activation of an ODS with 2/3 millions of records in BW 3.0b SuppPack24.
Does someone know how to reduce the activation time????
Parallel ODS Object Data Activation (BW 3.x) can improve activation time significantly.
1)Data Activation can be processed in parallel and distributed to server groups in the BW customizing (transaction RSCUSTA2) in BW 3.x. There are parameters for the maximum number of parallel activation dialog processes, minimum number of records per package, maximum wait time in seconds for ODS activation (if there is no response of the scheduled parallel activation processes within this time, the overall status is red) and a server group for the RFC calls when activating ODS data.
2)Do not set the BEx Reporting flag if you do not plan to Report on ODS objects in BEx or in Web. If your reporting requirements on ODS objects are very restricted (e.g., display only very few, selective records), use InfoSets on top of ODS objects and disable the BEx Reporting flag.
In BW 3.x, the SIDs are determined during activation, in BW 2.x during data load. ,hence increasing the Activation time
Hope this Helps