I want to retrieve JSON data against MDX queries on DeepSee OLAP cubes in InterSystems Caché. Any ideas?
You can use MDX2JSON project for that. It's RESTful web api for MDX2JSON transformation (also JSONP and XML/A). Also supports requests about Pivots, Dashboards and Widgets. Supports Caché 2014.1+.