title: SSAS Multidimensional Dynamic Dimension Security MDX
body: <p>I tried to implement Dynamic Dimension Security in SSAS 2012 <strong>Multidimensional</strong> Model. I have a little knowledge on this for I have already implemented row level security in SSAS Tabular using DAX.</p>
  <p>What I did in Tabular is exactly the same as described in MSDN.
  <a href="http://msdn.microsoft.com/en-in/library/hh479759.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-in/library/hh479759.aspx</a></p>
  <p>The DAX I used in tabular is:</p>
  <pre><code>**='Organization'[Project Id]=LOOKUPVALUE('Employee Security'[Project Id], 'Employee Security'[Login Id], USERNAME(), 'Employee Security'[Project Id], 'Organization'[Project Id])**
  </code></pre>
  <ul>
  <li>Organization - Dimension Table on which Dynamic filtering should be
  happened (on the basis of Project Id).</li>
  <li>Employee Security - Dimension Table with Login Id of users are stored</li>
  </ul>
  <p>I need to implement the same functioning dynamic security in Multidimensional model too.</p>
  <p>Can somebody help me with the MDX and steps that should be used here to achieve the same?</p>
  <p>If you want any more clarifications on my requirement please do ask the same.</p>
  <p>Thank You in Advance.</p>