title: how to join more than two mdx queries
body: <p>i need two join 6 queries in mdx which are fetching result from olap cube .
  problem is that all queries have different where condition and i want to join them on the basis of rows. the query is</p>
  
  <pre><code>WITH
  MEMBER MEASURES.CONSTANTVALUE AS 0
  SELECT 
  Union(MEASURES.CONSTANTVALUE,[Measures].[Totalresult])  on 0,
  NON EMPTY {Hierarchize(Filter ({[keyword].[All keywords]},([Measures].[Totalresult]=0)))} ON 1
  FROM [Advancedsearch]
  WHERE {[Path].[/Search]}
  </code></pre>
  
  <p>In above the filter will be changed in different queries
  how can we join this one.</p>