title: MDX Query Via Openquery Does Not Return Expected Data
body: <p>Need a better question title but here goes. We have a set of queries we are calling from SQL Server (2012) that use data from an OLAP cube. We pull this data in via an <code>OPENQUERY</code> call:</p>
  
  <pre><code>SELECT "[Time Period].[Month Full Code].[Month Full Code].[MEMBER_CAPTION]" AS timestring
  FROM openquery([SSAS_cube],'
      SELECT { } ON 0,
      NONEMPTY ({
          DESCENDANTS({[Time Period].[Month Full Code].[Month Full Code]})
      }) ON 1
      FROM [thecube]
      WHERE (
          [Geography].[Geo County Area].&amp;[1204000057]
      );
  ')
  </code></pre>
  
  <p>This is returning no data. However, if we run the MDX directly on the SSAS server we do get data:</p>
  
  <pre><code>SELECT { } ON 0,
  NONEMPTY ({
      DESCENDANTS({[Time Period].[Month Full Code].[Month Full Code]})
  }) ON 1
  FROM [thecube]
  WHERE (
      [Geography].[Geo County Area].&amp;[1204000057]
  );
  </code></pre>
  
  <p>This result set is a single column of available times that had data for the give area (with other parameters optional). I think the issue is that there is no column "header" on the MDX result but even doing a simple <code>SELECT * FROM openquery(...)</code> returns no data. How can I get this data to return via openquery call?</p>