[Mondrian] Mondrian output as a JSON file

Patrick Leckey patl at seewind.com
Mon Mar 19 10:35:27 EDT 2012


You'll still need to write a layer to translate form Mondrian JSON to D3 as well.  We've used D3 (sparingly, we just tested with it) and the way it expects the data to be structured is not what you will get out of Mondrian.

Thanks,
Pat

On 2012-03-19, at 10:32 AM, Luc Boudreau wrote:

> If you are using Mondrian with the XMLA servlet, you can make it spit
> out JSON responses instead of SOAP by setting your HTTP Accept header
> to "application/json" and Mondrian will answer in JSON directly
> instead.
> 
> Luc
> 
> On Mon, Mar 19, 2012 at 10:14 AM, Shehzad Ahmad Hashmi
> <s.hashmi44 at gmail.com> wrote:
>> Thanks for reply.
>> Actually I need to perform OLAP operations on data warehouse which is stored
>> in MySQL. The resulted data should be in JSON format which I will pass to
>> D3.js http://mbostock.github.com/d3 for visualizations. For data format I
>> have to use JSON format. Please any suggestions how to iterate MDX result
>> and convert it in JSON file. I am using Pentaho Mondrian for this purpose.
>> 
>> 
>> _______________________________________________
>> Mondrian mailing list
>> Mondrian at pentaho.org
>> http://lists.pentaho.org/mailman/listinfo/mondrian
>> 
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian



More information about the Mondrian mailing list