title: SQL to MDX Where IN clause
body: <p>I have a situation where I need to formulate an MDX query.The corresponding <code>SQL</code> query would look something like:</p>
  
  <pre><code>SELECT no_of_downloads 
  FROM   table_1
  WHERE  project_code IN ('abc', 'def', 'ghi' , .....)
  </code></pre>
  
  <p>I have the following MDX query formulated but i can only use it for one project code at a time.</p>
  
  <pre><code>SELECT 
    [Measures].[#Activity] ON COLUMNS
   ,Filter
    (
      [Organisation Dimension].[Txt Project Code].MEMBERS
     ,
      [Organisation Dimension].[Txt Project Code].CurrentMember.Name = 'KM_BNG'
    ) ON ROWS
  FROM [Activity Cube]
  WHERE 
    (
      [Activity Dimension].[Txt Activity Name].&amp;[Download]
     ,[System Dimension].[Txt System Name].&amp;[KShop] //ENTER CODE HERE//
     ,[Time Dimension].[Fiscal Hierarchy].[Fiscal Half Year Name].&amp;[2014-04-01T00:00:00]
    );
  </code></pre>
  
  <p>How to add more project codes in the list? </p>