Of Course, performance tuning will always be necessary, so sorry to disappoint you already. However, it does seem that SAP have had their performance wits about them when creating the new BW release 7.20.
Ramp up is scheduled for Q1 2010 according to this presentation: http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/d0ea8b43-26af-2c10-f1b5-bbb69060de87 The new release offers a wide variety of opportunities for more flexible data modeling, tighter integration with BusinessObjects, Teradata and HP Neoview database connection but also a significant promise of performance improvement in the major bottleneck in BW data load: DSO activation time.
It seems that BW 7.20 will lead to a significant improvement in load performance. The bottleneck in BW load processes have always been the DSO activation. SAP are taking a great step ahead by changing the activation procedure of DSOs. The promise of 1) activation by package fetch and 2) runtime option of “new, unique data records only” will undoubtedly have a significant improvement in load performance. I have to say that this functionality is long overdue, but great that it is finally coming.
What should SAP include next time?
SAP should make it possible to select whether change log should be updated when loading to DSO. If you remember to run full loads to cubes this setting won’t be an issue. This may be the next step – I certainly hope so.