{"id":511,"date":"2011-04-13T11:45:23","date_gmt":"2011-04-13T18:45:23","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/?p=511"},"modified":"2011-04-13T11:45:23","modified_gmt":"2011-04-13T18:45:23","slug":"why-olap4j-1-0-matters","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2011\/04\/13\/why-olap4j-1-0-matters\/","title":{"rendered":"Why OLAP4J 1.0 matters"},"content":{"rendered":"<p><a href=\"http:\/\/julianhyde.blogspot.com\/2011\/04\/olap4j-version-10-released.html\">Julian Hyde<\/a> and his cohorts on the <a href=\"http:\/\/mondrian.pentaho.org\/\">Mondrian project<\/a> have been busy at work for nearly 5 years (spec 0.5 done in 2006!) working on the difficult, but worthwhile effort of standardizing client side access to OLAP in Java.<\/p>\n<p>They just <a href=\"http:\/\/www.pentaho.com\/news\/releases\/pentaho-announces-a-new-era-in-open-standards-for-analytics\/\">released version 1.0<\/a>! This is a big deal; bigger players have attempted and failed at this before (ahem <a href=\"http:\/\/www.jcp.org\/en\/jsr\/detail?id=69\">JOLAP<\/a>).\u00a0 Kudos to Julian, Luc and the others involved to get such a *real* standard in place!<\/p>\n<p>There&#8217;s a few reasons why this matters to everyone in Business Intelligence.\u00a0 Not just Java devs and Open Source BI fans.<br \/>\n<\/p>\n<ul>\n<li><em><strong>Only existing &#8220;de facto&#8221; standards are owned by MSFT<\/strong><\/em>\n<p>XML\/A was touted as **the** industry standard for OLAP client server communications.\u00a0 You can think of XML\/A as the SOAP equivalent of OLAP client libraries.\u00a0 There are a few problems with this.First is that <strong>MSFT always treated this like they do all &#8220;open<\/strong>&#8221; standards; just open enough to get what they need out of it (SQUASH JOLAP) but never really open. \u00a0 \u00a0 For instance, reading the spec, notice that the companies involved specifically note that they all absolutely reserve the right to enforce their patent rights on their technology, EVEN IF it&#8217;s part of the spec.\u00a0 ie, it&#8217;s open, but if you actually IMPLEMENT it you might have to pay MSFT for it.<\/p>\n<p>Second is that <strong>XML\/A is now a fragmented standard<\/strong>.\u00a0 Similar to SQL, MDX support and other line protocol extensions (ahem, Binary Secured XML\/A) means that there&#8217;s no one really making any sort of technology toolkit, collection of drivers, etc.\u00a0 Simba does much of this in their lab in Vancouver, but they&#8217;re the exact opposite of open.\u00a0 In fact, when the XML\/A council vanished they pounced and picked up the site which is now a simple shill for their products.\u00a0 A couple of guys at a single company without any open publication on variations in MDX\/implementations is counterproductive to real interoperability.<\/p>\n<p>Third is that <strong>SOAP is soooooo 1999<\/strong>.\u00a0 SOAP is fundamental in XML\/A and there are many interesting (Saiku) ways of serving client server.\u00a0 REST, direct sockets, in memory, etc.<\/li>\n<p><\/p>\n<li><em><strong>Helps keep Mondrian from being fused to Pentaho Analyzer <\/strong><\/em>\n<p>Mondrian is a very successful open source project and serves as the basis (server part) of Pentaho&#8217;s Analyzer (acquired from LucidEra).\u00a0 Pentaho has clearly signaled their (lack of) commitment to upkeep of their open source frontends; Analyzer is proprietary software that Pentaho has committed all their OLAP UI efforts behind, leaving the community with an aging JPivot front end to Mondrian.\u00a0 Clearly underestimating what the community has to offer, the community has <a href=\"http:\/\/twitter.com\/#!\/SaikuAnalytics\/status\/58104929939750912\">delivered<\/a> a replacement project <a href=\"http:\/\/analytical-labs.com\/\">Saiku<\/a> to address this.<em><\/em><em> <\/em><\/p>\n<p><em>OFF TOPIC: I&#8217;ve made several Open Source BI predictions and with the exception of Pentaho Sreadsheet Services (which technically wasn&#8217;t OSS) I&#8217;ve been right every time.\u00a0 Here&#8217;s one for ya: <strong>Saiku will outshine Analyzer in the next 18mos<\/strong> and both technologies will be worse off because Pentaho, ironically and increasingly, chose proprietary instead of community. Ahhh&#8230; I feel better having said it.<\/em><\/p>\n<p>Keeping Mondrians primary exterior API as a standard helps ensure that Mondrian can not be subsumed (entirely) by Pentaho and that innovation can continue with multiple community projects doing shiny UI work on top of Mondrian.<\/li>\n<p><\/p>\n<li><em><strong>A single, pragmatically useful API enables binding to other languages as well (ie, non Java)<\/strong><\/em>\n<p>Saiku, basing their open source RESTful server on top of OLAP4J has now enabled cool mashable OLAP access to not JUST Mondrian (which was already available via SOAP\/.xactions) but anyone else who creates a driver (SAP, SSAS, etc).\u00a0 By actually having a real project that can collect up a real open driver implementation with a few implementations means that projects like Saiku (which actually has client APIs for C, Obj-C, Ruby, ActionScript, etc).<\/p>\n<p>I wouldn&#8217;t be surprised if there are others layers (ADOMD?) that leverage OLAP4J as well.<\/li>\n<\/ul>\n<p>Java OLAP nerds <a href=\"http:\/\/www.olap4j.org\/\">unite<\/a>!\u00a0 Non Java nerds checkout <a href=\"http:\/\/analytical-labs.com\/\">Saiku<\/a>.\u00a0 Pentaho users\/customers know that OLAP4J is good for keeping Mondrian open and innovative.\u00a0 OLAP innovation is alive and well, led by Mondrian, Saiku, Pentaho, etc.\u00a0 Happy MDX&#8217;ing.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Julian Hyde and his cohorts on the Mondrian project have been busy at work for nearly 5 years (spec 0.5 done in 2006!) working on the difficult, but worthwhile effort of standardizing client side access to OLAP in Java. They just released version 1.0! This is a big deal; bigger players have attempted and failed [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[9,11],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/511"}],"collection":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/comments?post=511"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/511\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=511"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}