title: How are most people using MDX queries? Should I be using MDX results to drive a web UI?
body: <p>I'm trying to do some analysis for an upcoming project.</p>
  
  <p>It has something to do with trending, charting and analysis; so think MAX, MIN, AVG, SUM etc over a period of time.</p>
  
  <p>Say we have an OLAP cube that's setup to figure out these calculations against a time dimension. </p>
  
  <p>In theory the backend is there to query the cube and get the results for some object A for some property B for a bunch of days in a month or a year or whatever the case may be (i.e over the last 5 years and you can manipulate the rendered date range by using a slider window similar to those used on finance stock charts to expand or narrow your field of view).</p>
  
  <p>Some of us are thinking we can query the cube using MDX to drive a UI that uses some HTML 5 charting tools.</p>
  
  <p>I'm new to OLAP, MDX, Cubes etc
  but it seems that there isn't a clean way of retrieving the results of an MDX query in .NET code (we'll be using C# in an MVC web site).</p>
  
  <p>So far what we've found will probably work best is ADOMD.</p>
  
  <p>I'm wondering if there are any alternatives folks can suggest.</p>
  
  <p>Is anyone using an OLAP cube and MDX queries to drive their web site?</p>
  
  <p>It seems to me that if the cube is already setup properly to answer questions like object A for property B for the last 2 months, then we should be able to query the cube for exactly that data and display it how we see fit on some UI. I'm not sure there's a clean way of doing so though.</p>
  
  <p>Any suggestions, insight, ideas would be appreciated.</p>