| Happy with? Ho ho I'm never happy ;) Look, I'm not going to say I love SAP BW - I loathe the costly bohemoth it has become, and I hate even more the so-called experts who are just out of business school with no CS knowledge, and those consultants who are "in it for the money". That stinks and there are many many of them. But whenever I look at any competitive BI system, on a technical level SAP BW is way ahead of the game in so many areas. I can't even begin to list them properly: Near code-ess datawarehouse Follows the Kimball method to-the-letter A truly usefull way of snow-flaking and an astonishing delta load mechanism source database independent scripting (if necessary) Having said that only 1 client in the last 14 years has ever implemented SAP BW correctly and cleanly, and (incredibly) with no data load errors for 2 years. So I know how good it can be with the right person at the top (me;) it just costs the earth. So to answer your question, the rest just look like very hard work, and almost all are by-and-large script instensive, which in the long run is unmaintainable because the business cannot understand it. And that is the whole purpose of a good warehouse - in my view - it needs to present a model that mirrors the business processes. |