title: OBIEE remove dimension value based on measure result
body: <p>One of my dimension contains the different divisions of the company. I have one division which doesn't exist anymore but I want to keep this to check the results of previous years and months. 
  How do I dynamically eliminate this value of the dimension when it doesn't have a measure anymore? 
  First I was thinking that adding a filter where the measure should be > 0 or 'not null' but this doesn't seem to do the trick. The dimension keeps showing up.</p>
  
  <p>Thanks!</p>