title: IIF MDX statement, active flag = 1 or 0
body: <p>I've got a product dimension in my SSAS project and i've got an active flag attribute.</p>
  
  <p>I'm trying to make my cube say "Active" or "Not active". I'm trying to accomplish this through a calculated member script.</p>
  
  <pre><code>IIF([Dim Product].[Active Flag]=1, "Aktiv", "Ikke Aktiv")
  </code></pre>
  
  <p>As you can see, I'm a complete noob, so I'm not sure what I'm doing wrong here.</p>
  
  <p>Any help would be greatly appreciated!</p>
  
  <p>Thank you</p>