What is the future of Infocubes?
Today I had a very interesting discussion at lunchtime about the future of Infocubes and current state of BI and BO integration with two of my colleagues, Michael and Steve. Please read the dialogue:
Michael: “I read today an interesting article about SAP The BW – HANA Relationship. He added, that this is a technology known for years and was third-party companies already do. I read the article, but then I sudenly asked myself, what does this mean for Infocubes?”
Me: “What do you mean exactly?”
Michael: “Infocubes are saved in a star-scheme on the database. With In-Memory technology the star-scheme gets obsolet and is replaced by a flat table structure, data access is organized by columns and indizes. Why should you think of a star scheme in modeling and take care how you order your characteristics in an Infocube?”
Me: “You’re right. Number of key figures and characteristics in a cube and how they are ordered loses importance. In-memory doesn’t care if it is a flat table or a star scheme what you want to store. I learned at SAP training how to model a cube, how to create dimensions, paying attention to line items. All this gets obsolete with In-Memory.”
Steve: “Yes, I expect that SAP will soon dismiss the idea of a star scheme. Also in terms of Large Scalable Architecture, just think of DataStoreObjects. You won’t need cubes.”
Me: “In my opinion Cubes and aggregates will serve only as fallback, if something is wrong with In-Memory hardware because of any failures. Star scheme is important only for small and mid-size companies, which can’t afford In-Memory technology.”
Michael: “Hardware prices will drastically going down and In-Memory will be affordable for small and mid-size companies in 5 to 10 years. My expectation is that in 5 to 10 years, SAP will dismiss the star scheme for Infocubes!”
Me: “You might be right for this timeframe. In regard of modeling, new BO Data Services come into my mind. With this tools you don’t even need to take care about ETL and writing complex transformations. Data services have a graphical user interface, are easy to lean and fast in data transformations. I expect, Data Services will make it easier to integrate non-SAP systems into SAP BW. You don’t need to write hard-coded ABAPs any longer.”
Steve: “Right, until now, SAP BW is the best warehouse solution, if you have many SAP systems or are a SAP minded company. But there are other customers outside, which run their warehouses on Oracle, Microsoft and IBM. They have sometimes a multi-layered BW architecture, where data from a local SAP BW will be loaded into a global operating Microsoft data warehouse for example.”
Me: “Yes, for these companies BO Data Services is a great tool. And for SAP sales it’s a good possibility to win new customers. That was the idea with acquisition of Business Objects in 2008 – win new customers and making SAP BW attractive for non-SAP customers. By the way, do you remember the reporting problems? How difficult it was to create a customer report with BEx in customers corporate design?”
Michael: “In fact, this has become much easier now. You can choose from Crystal Reort,s WebIntelligence or Dashboard Design. But still you have some landscape issues. How many BO servers, how many BW servers reagarding transports? What about portal server and web server? This landscape is getting very fast very complex and not every company can handle this.”
Me: “As far as I know, with the new SAP BO Business Intelligence 4.0 integration gets even tighter. Let’s watch the video of new features in SAP BO BI 4.0. In my opinion, the tools will grow together over the next two years and known problems today will fade away. BICS as interface gets more and more important. It promises fast access to BI data, replacing MDX interface and queries.”
Steve: “In fact, I have never thought of that. But, yes, you’re right. BICS replacing MDX could be an issue for many third-party tools, which rely on the MDX interface. SAP will enhance the BICS and make it really fast, accessing BI data. Tools using MDX will loose performance and thus acceptance. This can change mind of some customers to question their existing front end strategy. Maybe some of them will change to pure SAP BO front ends, with all migration issues which may arise.”
Me: “BI 4.0 and SAP BW 7.3 with tight Data Services integration starts to change the world, how you think of BI today and how you have to think about it in 2 years or even less. All inventions together lead to a paradigm change – by customers and partners and how may be BI projects will be done in the future.”
With that, we stopped our discussion and went back to work.
I think, SAP BO BI 4.0 and SAP BW 7.3 ill really change SAP BI in future. I can’t await to get hands on on both tools and try them out!