title: MDX to SSAS calculation
body: <p>I have written a MDX query which works fine in SQL Server Management Studio.  My query is as follows:</p>
  
  <pre><code>SELECT [Measures].[Item Count] 
  ON 0 
  FROM [Inventory]
  where [DateDiscontinued].[Date].[Discontinued Cal Year].&amp;[0].&amp;[0]
  </code></pre>
  
  <p>This query gives me all the items which are Discontinues.Now the problem is that when I copy paste the query in BIDS(SSAS Cube Calculation) as a calculated Member I get an error. It says it can't read the select statement. Do I need to write different MDX to support SSAS Calculated member or different function which supports SSAS Calculated Memeber?</p>