title: JSON Result From SSAS Cube
body: <p>I am new to working with Business Intelligence/Analysis Services and MDX queries. I am developing a web app that pulls/embeds reports from a report server (SSRS reports build upon this cube data), however the result is slow and the resulting look is lacking IMO. I am also generating chart widgets using the same method (looks even worse).</p>
  
  <p>To find a new solution one task at a time, I have explored the possibility of generating the widgets (bar, pie, line chats etc...) with some really nice SVG javascript libraries. However, these libraries are wanting to be supplied data in JSON or XML (some other formats supported like CSV as well...).</p>
  
  <p>I'd like to ditch my current use of the reporting widgets, and attempt to render my own charts based on this cube data. However, I am at a loss for gathering the data in the appropriate format. I'd prefer JSON to save file size, but XML will suffice. Any suggestions?</p>