{"id":152,"date":"2006-04-10T06:37:21","date_gmt":"2006-04-10T13:37:21","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/?p=152"},"modified":"2006-04-10T06:37:21","modified_gmt":"2006-04-10T13:37:21","slug":"open-source-olap-standards-do-work","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/04\/10\/open-source-olap-standards-do-work\/","title":{"rendered":"Open Source OLAP : Standards DO WORK!"},"content":{"rendered":"<p>A while back I had an <a href=\"http:\/\/www.bayontechnologies.com\/bt\/blog\/archives\/2006\/02\/this_graph_is_v.php\">impromptu collaboration with Chris Harrington<\/a> to see if any of his XML\/A clients could interoperate with Mondrian.  Our initial results were encouraging and Chris has taken some time to <a href=\"http:\/\/www.activeinterface.com\/b2006_3_29.html\">put Mondrian to task on his XML\/A compatibility tests<\/a>.<\/p>\n<p>His results, well, I&#8217;ll let them speak for themselve:<\/p>\n<blockquote><p><i>I have a cmd file full of xmla.wsf invocations to test many kinds of Discover calls and a few Execute calls. So I had this as a ready-made compatability test. I just changed the XML\/A URL and the catalog name (&#8220;FoodMart&#8221; instead of &#8220;FoodMart 2000&#8221;) and ran the script.<br \/>\n<b>All of my XML\/A invocations except one worked against Mondrian.<\/b><\/i><\/p><\/blockquote>\n<p>Apparently MSAS is slight more forgiving on some syntax issues (brackets, curly braces and such) but overall Mondrian can actually BE an XMLA provider to clients.<\/p>\n<p>Very encouraging&#8230; Considering the economics of inexpensive <a href=\"http:\/\/www.dell.com\">Lintel servers<\/a>, <a href=\"http:\/\/www.bizgres.org\">bitmap indices and partitioning<\/a>, and the aggregate table feature in <a href=\"http:\/\/www.pentaho.org\/index.php?option=com_content&amp;task=view&amp;id=34&amp;Itemid=79\">Mondrian<\/a>:  building a reasonable (ActiveInterface.com<\/a>.  Chris provides BI consulting services but also has a couple of cool XMLA clients.<\/p>\n<p>PS &#8211; All of this because of investing in the XMLA standard.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A while back I had an impromptu collaboration with Chris Harrington to see if any of his XML\/A clients could interoperate with Mondrian. Our initial results were encouraging and Chris has taken some time to put Mondrian to task on his XML\/A compatibility tests. His results, well, I&#8217;ll let them speak for themselve: I have [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[9],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/152"}],"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=152"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/152\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=152"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}