title: Parameterize MDX in SSRS
body: <p>Relatively new to MDX but familiar with SSRS and I have a query that works just as I want it to in the query designer in SSMS however I'm not quite sure how to parameterize this in SSRS.</p>
  
  <p>Query returns department and shift as dimensions and Hours and Period as Measures with the query being filtered by a fiscal year and the Period measure as a specific period for that year.</p>
  
  <p>Query works as expected but do not know how to convert to SSRS by implementing parameters for Fiscal Period and Fiscal Year.</p>
  
  <p>Query:</p>
  
  <pre><code>WITH MEMBER [measures].[Period] AS 
  SUM([Date].[Fiscal Period].[P9],[Measures].[Hours])
  
  SELECT NON EMPTY [Department].[Department].[Department] * [Associate].[Current Shift].[Current Shift] on Rows,
  {[Measures].[Hours], [Measures].[Period]} ON Columns
  FROM Personnel
  WHERE [Date].[Fiscal Year].[FY2015]
  </code></pre>