After addin more and more aggregates to the cubes, it becomes tough to estimate when the load would finish, as sometimes the Attribute Change Run takes 10 min to run, sometimes, 2 hours.
There are many ways to deal with it. For example, reduce the percentage of DB statistics calculation, switch off the aggregates…
The following SAP OSS note might help. But need to be careful with the warnings in the same note.
Note 555030 – Deactivating BW-initiated DB statistics
You can deactivate the DB statistics initiated by the BW system by making the following entry in the RSADMIN table. You can use the SAP_RSADMIN_MAINTAIN ABAP report to do this:
-
- Object: DB_STATISTICS
-
- Value: OFF
Note that the RSADMIN table is buffered. You should execute a /$tab RSADMIN (invalidates buffers for RSADMIN) or /$sync (invalidates all table buffers) command afterwards.