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.
BW 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.
No comments:
Post a Comment