title: SSAS - Could Dimenstion attribute value calculated based on another dimension attribute value?
body: <p>Usually the dimension attribute is used in Cube for filter or slice cube. So the dimension attribute value should be set by user, when user access cube via excel. Is it possible to dynamically calculate dimension attribute value? For example: 
  Dim_A.Attri1 has value: a, b
  Dim_B.Attri2 has value: 0, 1</p>
  
  <p>Here if user set Dim_A.Attri1 as value: a and Dim_B.Attri2 has value 0, the cube measure shows number 100, if user set Dim_A.Attri1 as value: b and Dim_B.Attri2 has value 1, the cube measure shows number 200. The both combinations are correct.</p>
  
  <p>But user has to set 2 dimension attributes. Is it possible to set in cube Dim_B.Attri2 value calculated based on Dim_A.Attri1, so that:
  When Dim_A.Attri1 = a, then Dim_B.Attri2 = 0
  When Dim_A.Attri1 = b, then Dim_B.Attri2 = 1</p>
  
  <p>User doesn't need to set two dimensions. I didn't find where can program MDX in dimension attribute property, only in DefautMember. But it doesn't work for this purpose. Could some one help me? </p>
  
  <p>Thanks in advance.</p>
  
  <p>Jane</p>