OSBI/saiku — Issue #18: MDX endpoint is inconsistent
Author: buggtb
Created: 2011-10-11 14:46:05+00:00
State: open

The /mdx endpoint sends application/json Content-type but returns text. Backbone can't read the returned data.

Request:
Host saiku-ui.tiemonster.cloud9ide.com
User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0
Accept application/json, text/javascript, /*; q=0.01
Accept-Language en-us,en;q=0.5
Accept-Encoding gzip, deflate
Accept-Charset ISO-8859-1,utf-8;q=0.7,;q=0.7
Connection keep-alive
X-Requested-With XMLHttpRequest
Referer http://saiku-ui.tiemonster.cloud9ide.com/

Expected response:
Date Wed, 27 Jul 2011 17:33:34 GMT
Content-Type application/json
Vary Accept-Encoding
Content-Encoding gzip
Content-Length 124
Keep-Alive timeout=15, max=91
Connection Keep-Alive

{ mdx: "SELECT
NON EMPTY {Hierarchize({[Gender].[Gender].Members})} ON COLUMNS,
NON EMPTY {Hierarchize({[Product].[Product Family].Members})} ON ROWS
FROM [Sales 2]" }

Returned response:
Date Wed, 27 Jul 2011 17:33:34 GMT
Content-Type application/json
Vary Accept-Encoding
Content-Encoding gzip
Content-Length 124
Keep-Alive timeout=15, max=91
Connection Keep-Alive

SELECT
NON EMPTY {Hierarchize({[Gender].[Gender].Members})} ON COLUMNS,
NON EMPTY {Hierarchize({[Product].[Product Family].Members})} ON ROWS
FROM [Sales 2]