Cube Data in JSON Format

Question

Is it possible to query Analysis Services and have it return the result data in JSON format?

Answer 1

Hi,

I do not think this is possible without some development effort. The Analysis Services Server delivers the data back as XML, in a format which is either Multidimensional or  Tabular format, as documented e. g. here: http://msdn.microsoft.com/en-us/library/ms186604.aspx. This is the low level interface.
Based on this, there are some client libraries which offer access to the data in different formats, like ADOMD.net (http://msdn.microsoft.com/en-us/library/microsoft.analysisservices.adomdclient.aspx), the AS OLEDB provider (http://msdn.microsoft.com/en-us/library/ms146862.aspx), or OLAP4J (http://www.olap4j.org/).
You would have to iterate through the result yourself to generate the JSON format.

Frank