title: Using OR condition in MDX with different hierarchies of same dimension
body: <p>I would like to get data from cube where [Product].[Product Level2].&amp;[S1050]&amp;[S1050.080] OR [Product].[Product Level4].&amp;[S1060.012.701003]. <strong>So combine two hierarchies from same measure in set.</strong></p>
  
  <pre><code>SELECT NON EMPTY { 
      [Measures].[Product Sales], [Measures].[Sales Quantity] 
  } ON COLUMNS, 
  NON EMPTY { (
      [Product].[EAN CODE].[EAN CODE].ALLMEMBERS 
      * [Product].[Product].[Product].ALLMEMBERS 
      * [Date].[Calender Week].[Calender Week].ALLMEMBERS 
      * [Store].[Store Code].[Store Code].ALLMEMBERS 
      * [Store].[Store].[Store].ALLMEMBERS 
  ) } ON ROWS 
  FROM ( 
          SELECT ( -{ [Store].[Store Code].&amp;[0032], [Store].[Store Code].&amp;[0033] } ) ON COLUMNS FROM ( 
              SELECT ( { [Date].[Calender Week].&amp;[2019]&amp;[IW201906] } ) ON COLUMNS FROM [Cube]
          )
      )
  WHERE ( 
      {[Product].[Product Level2].&amp;[S1050]&amp;[S1050.080], [Product].[Product Level4 Code].&amp;[S1060.012.701003]}
  ) 
  </code></pre>
  
  <p>The above query is returning "<strong>Members, tuples or sets must use the same hierarchies in the  function.</strong>"</p>
  
  <p>Thank you for helping</p>