« September 2007 | Main | November 2007 »

October 2007

October 31, 2007

Business Objects Insight 2007

I just got back from the Business Objects Insight Conference and wanted to talk about their new OLAP product, Voyager. Before I go on, I want to disclose that my company, Simba Technologies, does work for BOBJ and we are a BOBJ Technology Partner. Also, what is written here is only my opinion.

A side comment: The big question hanging over everyone at the BOBJ conference was “What does the acquisition by SAP mean?” It was interesting that the BOBJ people were told not to comment on this. So, even though I know a lot of people at BOBJ, no one was talking. What was interesting was at the keynote, they had a video from Henning Kagermann, the CEO of SAP. Basically, Henning’s message was that SAP was happy to acquire BOBJ and would be running it as a separate group within SAP. BOBJ’s CEO, John Schwarz and BOBJ’s Founder, Bernard Liautaud, both also spoke in the keynote and also said the same thing. They said they are excited to be part of the SAP Group. The reality is that this deal has not yet closed at this time, so the two companies must still operate as independent entities. Everyone is figuring this deal will close in Q1 of 2008; my guess is don’t expect a lot till then.

Many of you know that BOBJ has a new OLAP product called Voyager - http://www.businessobjects.com/pdf/products/queryanalysis/ds_businessobjects_voyager.pdf. Voyager has been around for about a year now and it is an interesting product. It is a good offering from BOBJ in the OLAP space. BOBJ has had a lot of success in SQL reporting and if they keep investing solidly in Voyager, I expect they will have a lot more success in OLAP/MDX reporting and analysis. Previous to Voyager, BOBJ’s OLAP solutions were based on Crystal Reports and Web Intelligence with OLAP Universes. Voyager does more – it is an AJAX client and it also allows you to access and analyze multiple OLAP sources.

The Voyager session that I attended was titled “OLAP Analysis with Voyager – What’s New, What’s Planned”. It was presented by John MacGregor (Product Manager) and Ian McAlpine (Program Manager). They talked about the product and gave a very nice demo. They explained a lot of the features of the current product and talked about futures. It is interesting that they plan on supporting AIX and Linux. What is also interesting in this product is that “Supported OLAP databases include those from Microsoft, SAP, IBM, and Oracle (including Hyperion Essbase).” Being a connectivity person, I find this interesting. Voyager is an OLAP client from the largest BI products company that will support all of the major MDX OLAP servers. If you read my previous October 24th blog posting about MDX being the de facto standard for OLAP and multi-dimensional servers, you will understand why I find Voyager’s connectivity story interesting. Voyager will have native MDX connectivity to more MDX OLAP servers than even Microsoft Excel. Anyone wanting to have an OLAP client that works in a heterogeneous MDX server world will find Voyager to be something that they should definitely consider.

Yes, there are other products out there like Panorama that support MDX across all the major OLAP servers (http://www.panorama.com/news/news/archives/2007/aug-20-2007.html), but having a company the size of Business Objects doing this definitely is a game changer. If SAP continues to support Business Objects as an independent division and keeps investing in Voyager having open connectivity to all MDX data sources, I believe we will have achieved with MDX in the multi-dimensional world what we have with SQL in the relational world – true standards-based interoperability between clients and servers from different vendors.

One other thing that I also enjoyed during John and Ian's session is that they asked the audience for feedback on what additional features and functionality customers were looking for from Voyager. A number of people threw out ideas, and the discussions about Voyager futures continued after the session with a few people for a good 15-20 minutes. It is nice to see people who enjoy what they do and are so willing to listen to what their users and customers think.

October 24, 2007

MDX - History and Evolution

I'd like to highlight some MDX history, specifically how it has been adopted by many companies on the server side as an access means to OLAP/multi-dimensional data and has become the de facto query language for OLAP/multi-dimensional servers today. Having had an opportunity to collaborate with many companies over the years, I've seen some very interesting trends in MDX support.

Initially, server-side MDX was supported by companies like Microsoft, SAP, SAS and Applix. After which you had a lot of other companies support MDX, such as ALG Software, INEA Corporation and MIS. This was all good. However, for MDX to become a standard, it needed even broader support.

A big turning point for MDX was when Hyperion partnered with Microsoft on MDX and formed the XMLA Council. This was significant because Essbase was (and still is) a major name in the OLAP server market. IBM used to resell Hyperion’s Essbase as DB2 OLAP, and when Essbase added MDX support, IBM customers got it as well. This brought MDX to yet another level in terms of becoming a standard.

By around 2002, when Hyperion shipped a version of Essbase that supported MDX, on the server side, MDX was now supported by pretty much everyone except for Oracle. Without Oracle, there was a big hole, but we were close to broad support. Oracle, of course, is a huge player in the database market.

With all the industry consolidation, a lot has changed. Cognos has acquired Applix. Systems Union acquired MIS, and then Systems Union was acquired by Infor. Oracle acquired Hyperion. Business Objects acquired ALG Software, as well as Cartesis, which had previously acquired INEA Corporation. Also, IBM stopped reselling Essbase a few years ago.

So, we add Oracle (through their Hyperion acquisition), but we lose IBM because they no longer resell Essbase. The interesting news is that IBM is about to ship their DB2 Viper 2 product at the end of October, and what did you expect? IBM supports MDX in the product.

So, where does that leave MDX on the server side? From what I can see today, everyone has it:

  • Microsoft Analysis Services
  • SAP BW (also called SAP NetWeaver BI)
  • Oracle Essbase
  • Business Objects
  • Cognos Applix
  • IBM DB2
  • Infor MIS Alea

There are also a lot of smaller players in the OLAP space, such as Panoratio and Descisys, and they also support MDX on the server side.

Therefore, MDX is the de facto query language standard for OLAP/multi-dimensional servers today.