title: SSRS - Can I hardcode Select ALL for multivalue parameter
body: <p>I'm facing a known problem with <a href="http://connect.microsoft.com/SQLServer/feedback/details/268032/default-does-not-get-refreshed-for-cascading-parameters" rel="nofollow">default values for a cascading parameters</a>. Since my parameters are coded in MDX I cannot find any specifc idea for a workaround. </p>
  
  <p>Rather than trying to change a parameter query, I thought to check if there is a possibility of hard coding SELECT ALL for a cascading, or any parameter for that matter. </p>
  
  <p>This is my Parameter dataset:</p>
  
  <pre><code>WITH 
      MEMBER [Measures].[ParameterValue] AS [Organisation].[Cost Centre Code and Description].CURRENTMEMBER.UNIQUENAME 
  SELECT  
      [Measures].[ParameterValue]
  ON COLUMNS , 
  [Organisation].[Cost Centre Code and Description].[Cost Centre Code and Description].ALLMEMBERS ON ROWS 
  FROM 
  (SELECT STRTOSET(@CC_Caption, CONSTRAINED) ON COLUMNS FROM 
  [CUBE] )
  </code></pre>
  
  <p>Would anyone have an idea how to hardcode <code>SELECT ALL</code> for an SSRS parameter?</p>
  
  <p>Thanks for any points :)</p>