title: MDX with snowflaked dimensions
body: <p>I have an ordinary <code>DimProduct</code> which has a snowflaked <code>DimPriceList</code> where I store for each <code>ProductKey</code> different prices for the products.</p>
  
  <p>In a <code>MDX</code>, depending on certain product properties, I would like to display different prices for the products. The MDX would look something like this.</p>
  
  <pre><code>CASE 
  WHEN [Dim Product].[Value Group].CurrentMember.MEMBERVALUE = '02' THEN
      CASE 
      WHEN [Dim Product].[Stock Account Nr].CurrentMember.MEMBERVALUE = 101 THEN
          ([Dim Price List].[Sales1])
      WHEN [Dim Product].[Stock Account Nr].CurrentMember.MEMBERVALUE = 102 OR  
              [Dim Product].[Stock Account Nr].CurrentMember.MEMBERVALUE = 103 THEN
          ([Dim Price List].[Valuation])
      ELSE
          0
      END
  ELSE
      1 
  END
  </code></pre>
  
  <p>How can I now access the current membervalue of the <code>DimPriceList</code>? I just get 'All' as result and not the actual value for the current member. I've also tried [Dim Price List].[Valuation].CurrentMember.MEMBERVALUE but with no success. Appreciate any sort of help or hints.</p>