It’s classic web 2.0 technology. It does virtually nothing, yet changes everything. There is very little code (about 20K), an old-school enterprise architect would regard it as a trivial piece of protocol glue, and yet it opens the door to all kinds of mashups. Those mashups will get powerful OLAP data into the hands, and onto the screens, of the business users who care about that data.
Roland is a practical guy and a great communicator, so the presentation (and the download from google code) includes several examples of those mashups. I urge you to take a look at the recorded webinar.
A few issues came up during the webinar that are worth mulling over.
1. Query model
One thing that is missing is a query model. A query model allows you to represent the state of the current query, apply a transformation (say sorting on column #3, or adding a hierarchy to an axis), then generate a new MDX statement to send to the OLAP server. The demo Roland showed had a rudimentary query model, but in order to do more complex analyses, that query model will run out of road very quickly.
2. Cube metadata
Roland bemoaned the fact that getting the metadata for a cube (including dimensions, hierarchies, levels, measures) takes several XMLA round-trips.
He has a good point. Those round-trips may make the page load several times slower. We could easily extend Mondrian’s cube metadata request so that you can ask for those extra elements.
If it proves useful, other XMLA engines (such as PALO) could do the same, and heck, if the XMLA council is not asleep in their castle, they could add it to the next version of the XMLA spec. (Well, we can hope.)
3. Results in JSON
Mondrian’s XMLA servlet is written to generate elements, attributes, and nested collections of elements, and precious little of the code directly generates XML. It wouldn’t be too much work to generate JSON instead. The JSON would have the same structure as the XMLA, sans the irritating namespaces that are necessary in XML.
For example, the JSON response from
MDSCHEMA_CUBES could look like this:
I’d like to hear Roland’s (and the Mondrian, Pentaho, olap4j and PAT community’s) take on these points. Thanks again Roland for an informative webinar and a great new addition to the open source BI technology stack.