title: Error during select query MDX - Members, tuples or sets must use the same hierarchies in the function
body: <p>I'm trying to get the Lattitude &amp; Longitude of shops from OLAP Cube which will be passed in google map.</p>
  
  <p>I tried the following query:</p>
  
  <pre><code>select
  {
  [Productive_GIS].[Lat].[Lat],
  [Productive_GIS].[Lon].[Lon]
  } on columns,
  [Productive_GIS].[SHOPCODE WITHOUT DIST].[SHOPCODE WITHOUT DIST] on rows
  from
  [Consolidated Sales]
  </code></pre>
  
  <p>I am getting the following Error:</p>
  
  <p><strong>Query (2, 1) Members, tuples or sets must use the same hierarchies in the  function.</strong></p>
  
  <p>I want the result set in ONE of the following two formats:</p>
  
  <p><a href="https://i.stack.imgur.com/F90VY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F90VY.png" alt="enter image description here"></a></p>
  
  <p>OR</p>
  
  <p><a href="https://i.stack.imgur.com/9EtiV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9EtiV.png" alt="enter image description here"></a></p>
  
  <p>The snapshot of the CUBE:</p>
  
  <p><a href="https://i.stack.imgur.com/dVZjX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dVZjX.png" alt="enter image description here"></a></p>
  
  <p>Kindly Help me achieve this as I'm new to MDX.
  I will be converting this resultset into Asp DataTable for further proceeding on Google Maps</p>