<p>You might try xmla4js<br>
<a href="http://code.google.com/p/xmla4js/">http://code.google.com/p/xmla4js/</a></p>
<p>Or saiku<br>
<a href="http://analytical-labs.com/">http://analytical-labs.com/</a><br>
</p>
<div class="gmail_quote">On Mar 8, 2012 11:55 PM, "Shehzad Ahmad Hashmi" <<a href="mailto:s.hashmi44@gmail.com" target="_blank">s.hashmi44@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>Hi!</div><div>I am new to Mondrian. I am using it in my project for OLAP operations. I am testing it with Foodmart database. The problem is that I need the OLAP operations results in JSON format. I know that mondrian has the same structure as JSON in the form of hierarchies. I want to generate a JSON file as an output from the result of mondrian MDX query. The result should be similar to OLAP operations. I don't know how to parse the result generated from MDX query. Please help me as I have to use it in my FYP. Thanks.</div>
<div>Here is the code.</div><div><br></div><div> String connStr = "Provider=mondrian;" +</div><div> <span style="white-space:pre-wrap"> </span> "Catalog=/WEB-INF/FoodMart.xml;" +</div>
<div> <span style="white-space:pre-wrap"> </span> "JdbcDrivers=com.mysql.jdbc.Driver;" +</div><div> <span style="white-space:pre-wrap"> </span> "Jdbc=jdbc:mysql://localhost/foodmart;" +</div>
<div> <span style="white-space:pre-wrap"> </span> "jdbcUser=root;" +</div><div> <span style="white-space:pre-wrap"> </span> "jdbcPassword=;";</div>
<div> </div><div> String queryStr ="select {[Measures].[Unit Sales], [Measures].[Store Cost], [Measures].[Store Sales]} ON COLUMNS,"+</div><div> <span style="white-space:pre-wrap"> </span> "Crossjoin(Hierarchize(Union({[Promotion Media].[All Media]}, [Promotion Media].[All Media].Children)), {[Product].[All Products]})</div>
<div> ON ROWS"+</div><div> <span style="white-space:pre-wrap"> </span> " from [Sales]"+</div><div> <span style="white-space:pre-wrap"> </span> "where [Time].[1997]";</div>
<div><br></div><div> Connection connection = DriverManager.getConnection(connStr, null);</div><div> Query query = connection.parseQuery(queryStr);</div><div> Result result = connection.execute(query);</div>
<div> result.print(new PrintWriter(System.out)); </div><div><br></div><div><br></div>
<br>_______________________________________________<br>
Mondrian mailing list<br>
<a href="mailto:Mondrian@pentaho.org" target="_blank">Mondrian@pentaho.org</a><br>
<a href="http://lists.pentaho.org/mailman/listinfo/mondrian" target="_blank">http://lists.pentaho.org/mailman/listinfo/mondrian</a><br>
<br></blockquote></div>