title: How can I 'pull' data from an MDX OLAP Cube into a standard SQL Server table?
body: <p>I've been provided access to a cube and need to know if I can set up a stored procedure that can connect to a Cube and retrieve the contents (via an MDX Query).
  I need this to prevent having to export the data from the Management Studio or from Excel (via PowerPivot).
  I'm very new to cubes/olap queries so forgive any naivety I may show.</p>